Re: [PHP4BETA] PHP & Oracle Stored Procedure
| From: | Max Mukhin | Date: | Thu, 20 Apr 2000 13:47:47 +0000 |
| Subject: | Re: [PHP4BETA] PHP & Oracle Stored Procedure | ||
| References: | 1 | Groups: | php.version4 |
| Request: | Send a blank email to php-version4+get-13783@lists.php.net to get a copy of this message | ||
Vadim Tkachenko wrote:
>
> 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()");
use this statement:
"begin testproc; end;"
>
> 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
--
[mailto:hitower@don.sitek.net = ICQ 21050590 = Rostov-on-Don, Russia]
[ PGP fingerprint:2E26 C4FF 6940 1F7E 0188 1684 7B21 CF13 068D AE82 ]