Re: HELP! SP compiles but won't run

What is the point of the parameter profile_id as it is not used.

And this procedure strikes me as being a manual kludge where a sequence would serve you better. Is it really needed?

Jim Kennedy wrote:

> 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 Thu Mar 21 2002 - 09:53:37 CST