PHP & Oracle Stored Procedure
| From: | Vadim Tkachenko | Date: | Thu, 20 Apr 2000 12:57:52 +0000 |
| Subject: | PHP & Oracle Stored Procedure | ||
| Groups: | php.version4 | ||
| Request: | Send a blank email to php-version4+get-13780@lists.php.net to get a copy of this message | ||
Can I from PHP execute Stored procedures?
I have script:
$c1 = ocilogon("scott","tiger");
echo OCIServerVersion($c1)."\n";
OCIInternalDebug(1);
$upd_st=OCIParse($c1,"EXECUTE testproc()");
if (!OCIExecute($upd_st)){
$err=OCIError($upd_st);
die ("Error: ".$err["message"]);
};
OCIFreeStatement($upd_st);
OCILogOff($c1);
In result Error:
OCIStmtExecute: ORA-00900: invalid SQL statement