Re: Running ORACLE PL/SQL !
| From: | Thies Arntzen | Date: | Thu, 07 Sep 2000 08:20:16 +0000 |
| Subject: | Re: Running ORACLE PL/SQL ! | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-15668@lists.php.net to get a copy of this message | ||
On Thu, Sep 07, 2000 at 10:46:05AM +0300, Catalin Ciocoiu wrote:
> We have php4 with OCI library and we have tried to execute a PL/SQL
> procedure. The code is like this:
> $stmt=OCIParse($con,"execute myproc");
$stmt=OCIParse($con,"begin myproc; end");
should work. "execute" and "exec" are handled (and expanded to
"begin" ... "end" by sqlplus)
tc
> OCIExecute($stmt,OCI_COMMIT_ON_SUCCESS);
>
> we have got the following error:
> Warning: OCIStmtExecute: ORA-00900: invalid SQL statement in csicap.php
> on line 48
>
> The same query completes successfully when run from sqlplus.
> Can somebody tell us why a PL/SQL procedure which runs OK from SQLPLUS
> fails when run from PHP?
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
--
Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!"
Digital Collections Phone +49 40 235350 Fax +49 40 23535180
Hammerbrookstr. 93 20097 Hamburg / Germany