Re[2]: [phplib] How do u guys excute a PL/SQL block with oci8? From: Eric Wang (eric <email protected>)
Date: 07/04/00

help me, this problems is killing me.
it has tortured me for couple weeks.
I am drowning... :(

man ,it is the same error, actually in the beginning I put correct
pl/sql block in, but later I changed it becase this problem, I tried
lots of wacky thing try to make it work. :) damn it...
 
ORA-06550: line 1, column 69: PLS-00103: Encountered the symbol "" when
expecting one of the following:
begin declare end exception exit for goto if loop mod null pragma raise return select update while << close
current delete fetch lock insert open rollback savepoint set sql execute commit forall The symbol "" was
ignored.
Query :"declare aaa number := 3; begin insert into emp(emp_id) values (aaa); commit; end;"

On Tue, 4 Jul 2000 15:26:42 -0700 (PDT)
Ed Crotty <ejcrotty <email protected>> wrote:

> This is an oracle error - not a php or phplib error.
> for a pl/sql anonymous block, you need to 1) declare variables before
> the begin; 2) in this syntax aaa is not a bind variable (only use the :
> for bind variables); and 3) assignments in pl/sql require the := .
>
> instead of:
>
> "begin aaa number=3; insert into emp values (:aaa); commit; end;"
>
> it would be:
>
> "declare aaa number := 3; begin insert into emp(emp_id) values (aaa);
> commit; end;"
>
> I highly recommend the Feuerstein book from Oreilly for PL/sql.
>
> http://www.oreilly.com/catalog/oraclep2/
>
>
> --- Eric Wang <eric <email protected>> wrote:
> >
> > hi, guys!
> > anybody can help me?
> > I need excute a Oracle PL/SQL block in php4 with oci8 fuctions,
> > but I couldn't make the thing right, and could find the relevant
> > manual
> > nowhere, any goru give me a short example?
> >
> > I got the error like this:
> > ORA-06550: line 1, column 6: PLS-00103: Encountered the symbol ""
> > when expecting one of the following:
> > begin declare exit for goto if loop mod null pragma raise return
> > select update while << close current delete
> > fetch lock insert open rollback savepoint set sql execute commit
> > forall
> > Query :"begin aaa number=3; insert into emp values (:aaa); commit;
> > end;"
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: phplib-unsubscribe <email protected>
> > For additional commands, e-mail: phplib-help <email protected>
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Kick off your party with Yahoo! Invites.
> http://invites.yahoo.com/
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: phplib-unsubscribe <email protected>
> For additional commands, e-mail: phplib-help <email protected>
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: phplib-unsubscribe <email protected>
For additional commands, e-mail: phplib-help <email protected>