Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> OCISessionBegin: Error while trying to retrieve text for error ORA-12705 in /....
<?php
/* OCIDefineByPos example thies_at_digicol.de (980219) */
$db="(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = CP)(HOST =
csedu1)(PORT = 1521))) (CONNECT_DATA = (SID = RCL)))";
$conn = OCILogon("scott","tiger",$db);
$stmt = OCIParse($conn,"select empno, ename from emp");
/* the define MUST be done BEFORE ociexecute! */
OCIDefineByName($stmt,"EMPNO",&$empno);
OCIDefineByName($stmt,"ENAME",&$ename);
OCIExecute($stmt);
while (OCIFetch($stmt)) {
printf("number:".$empno."<br>");
printf("name:".$ename."<br>");
}
OCIFreeStatement($stmt);
OCILogoff($conn);
?>
Warning: Supplied argument is not a valid OCI8-Connection resource in
/home/oracle/public_html/oracle2.php on line 5
Warning: Supplied argument is not a valid OCI8-Statement resource in
/home/oracle/public_html/oracle2.php on line 7
Warning: Supplied argument is not a valid OCI8-Statement resource in
/home/oracle/public_html/oracle2.php on line 8
Warning: Supplied argument is not a valid OCI8-Statement resource in
/home/oracle/public_html/oracle2.php on line 9
Warning: Supplied argument is not a valid OCI8-Statement resource in
/home/oracle/public_html/oracle2.php on line 10
Warning: Supplied argument is not a valid OCI8-Statement resource in
/home/oracle/public_html/oracle2.php on line 14
Received on Mon Dec 03 2001 - 08:12:33 CST