Re: HELP! SP compiles but won't run

From: Tom Galczynski <tomg_at_asdsoftware.com>
Date: 25 Mar 2002 13:42:15 -0800
Message-ID: <689741.0203251342.559d55b2@posting.google.com>

Ed, I appreciate your taking the time to respond and thanks for the answer!
In my meager defense, the error DID say it was looking for a semicolon...among several other things! Also, since the error told me it was on line 3 and I had entered, as it turns out, not even one line at the worksheet prompt, I had assumed it was referring to line 3 of the procedure.

I feel better that 2 Oracle vets missed the problem as well. Now let's see, where is that darn manual.....

Cheers,
Tom Galczynski

ed.prochak_at_alltel.com (Ed prochak) wrote in message news:<e51b160.0203230852.3e809594_at_posting.google.com>...
> RTFM.
>
> The syntax is
>
> BEGIN
> p(1);
> END
> /
>
> The error told you it was looking for the semicolon (;)
>
> Alternate syntax for a procedure is:
>
> EXEC p(1);
>
> Which gets translated to the BEGIN/END pair as required.
>
>
> Ed Prochak
> Magic Interface, Ltd
Received on Mon Mar 25 2002 - 15:42:15 CST