Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: HELP! SP compiles but won't run
Where is your bind variable for your out parameter?
Jim
"Tom Galczynski" <tomg_at_asdsoftware.com> wrote in message
news:689741.0203201727.5e6f1c79_at_posting.google.com...
> Can anyone tell me what I am doing wrong in this stored procedure?
>
> CREATE PROCEDURE spKey (profile_id IN number, next_num OUT number)
> AS
> BEGIN
> SELECT fmlastkeyvalue + 1 INTO next_num FROM fmTableKey WHERE
> fmtable='rcriskassign';
> UPDATE fmtablekey SET fmlastkeyvalue=next_num WHERE
> fmtable='rcriskassign';
> COMMIT;
> END;
>
> It compiles without error, but when I go to run it like this
>
> spKey(1)
>
> I get the following:
>
> SQLWKS> begin spkey(1)
> 2>
> begin spkey(1)
> *
> ORA-06550: line 3, column 0:
> PLS-00103: Encountered the symbol "end-of-file" when expecting one of
> the following:
>
> := . ( % ;
>
>
> Thanks for your help.
>
> Cheers,
>
> Tom Galczynski
> tomg_at_asdsoftware.com
Received on Wed Mar 20 2002 - 20:06:04 CST