Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: HELP! SP compiles but won't run

Re: HELP! SP compiles but won't run

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Thu, 21 Mar 2002 02:06:04 GMT
Message-ID: <gebm8.86916$q2.9480@sccrnsc01>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US