Delicious Bookmark this on Delicious Share on Facebook SlashdotSlashdot It! Digg! Digg



PHP : Function Reference : Oracle Functions [deprecated] : ora_open

ora_open

Opens an Oracle cursor (PHP 4, PHP 5 <= 5.0.5)
resource ora_open ( resource connection )

Opens an Oracle cursor associated with connection.

Parameters

connection

A connection identifier, opened with ora_logon().

Return Values

Returns a cursor index or FALSE on failure. Details about the error can be retrieved using the ora_error() and ora_errorcode() functions.

ChangeLog

Version Description
5.1.0

The oracle extension is deprecated in favor of oci8.

Notes

When using oci8 as a replacement for the deprecated oracle extension, consider using:

oci_new_cursor()

Code Examples / Notes » ora_open

gabi_vlad

Exemple of ora_open, ora_exec, ora_parse
<?php
$utilizator='a';
$parolautl='b';
$baza='baza';
$conn = ora_plogon($utilizator.'@'.$baza, $parolautl) or die ('error'.ora_error());
$v_open = ora_open($conn) or die ('Could not connect.'.ora_error());
$v_parse = ora_Parse($v_open, "SELECT *  FROM perioade") or die ('select '.ora_error());
$v_execute = ora_Exec($v_open) or die ('Execution not made.'.ora_error());
print('<table>');
while (Ora_Fetch($v_open)) {
printf('<tr><td>%s</td></tr>',ora_getcolumn ($v_open, 3));
}
?>


Change Language


Follow Navioo On Twitter
ora_bind
ora_close
ora_columnname
ora_columnsize
ora_columntype
ora_commit
ora_commitoff
ora_commiton
ora_do
ora_error
ora_errorcode
ora_exec
ora_fetch_into
ora_fetch
ora_getcolumn
ora_logoff
ora_logon
ora_numcols
ora_numrows
ora_open
ora_parse
ora_plogon
ora_rollback
eXTReMe Tracker