Re: Running ORACLE PL/SQL !
| From: | Thies Arntzen | Date: | Thu, 07 Sep 2000 11:11:25 +0000 |
| Subject: | Re: Running ORACLE PL/SQL ! | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-15691@lists.php.net to get a copy of this message | ||
On Thu, Sep 07, 2000 at 12:09:43PM +0300, Catalin Ciocoiu wrote:
> We have tried the following query:
> $stmt=OCIParse($con,"begin sss; end");
sorry, you need a semicolon after the end :
stmt=OCIParse($con,"begin sss; end;");
tc
>
> and we have got the following error:
> Warning: OCIStmtExecute: ORA-06550: line 1, column 15: PLS-00103:
> Encountered the symbol "END" when expecting one of the following:
> ; The symbol ";" was substituted for "END" to continue. in csicap.php on
> line 48
>
>
> Thies Arntzen wrote:
> >
> > 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
>
> --
> 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