OCI code broken after upgrading to PHP4R1
| From: | kev | Date: | Fri, 02 Jun 2000 08:10:30 +0000 |
| Subject: | OCI code broken after upgrading to PHP4R1 | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-170@lists.php.net to get a copy of this message | ||
Hi,
I had to upgrade to PHP4R1, but now I get this error:
Warning: OCIStmtExecute: ORA-03113: end-of-file on communication
channel
in...
... from some code. The problem code appears to be this code:
$sql = "begin kp_limit('$sql',:mycurs,$off,$nrows); end;";
echo "\$sql = $sql<BR>\n";
$stmt = OCIParse( $this->conn, $sql );
OCIBindByName( $stmt, "mycurs", &$curs, -1, OCI_B_CURSOR );
OCIExecute( $stmt );
OCIExecute( $curs );
which is accessing an Oracle stored procedure. It worked fine before the
upgrade. What changes do I need to make to get it working again?
thanks,
- Kev