Re: HELP! SP compiles but won't run

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
tomg_at_asdsoftware.com (Tom Galczynski) wrote in message news:<689741.0203222151.10280349_at_posting.google.com>...
> Thomas, thank you! I appreciate your help. Now my problem is, I can
> compile your procedure in SQL Worksheet without error. However, when
> I go to run it by entering the following line in SQL Worksheet
>
> BEGIN p(1)
>
> I get the following result:
>
> ORA-06550: line 3, column 0:
> PLS-00103: Encountered the symbol "end-of-file" when expecting one of
> the following:
>
> := . ( % ;
>
> I am using Oracle 8.0. Is "BEGIN p(1)" correct syntax? Is there
> anything else I need to do in order to be able to run this properly?
> This is the first time I've tried to use a stored procedure to return
> a value so I'm sure it's something basic I am missing.
>
> Cheers,
> Tom G.
>
Received on Sat Mar 23 2002 - 10:52:45 CST