Mark,
How are you running it? If using SQL Plus+, I don't think you can have multiple CREATEs executing at the same time. When I created an SP builder, I had to send my DDL statements separately. It was a big PITA. The same builder creates SPs in Oracle or SQL Server and SQL Server allowed multiple blocks simply by breaking them up with a GO command. I thought the ; was supposed to do the same thing in Oracle. WRONG!!!
HTH.
>I am connecting to a database with version info: Oracle8i Enterprise Edition Release 8.1.6.3.0.
>
>I am trying to create an Oracle package that returns a cursor. This can be done but for some reason the following generates an error message on the CREATE OR REPLACE PACKAGE BODY line:
>CREATE OR REPLACE PACKAGE GetPermits AS
>Type RetCursor Is Ref Cursor;
>
>Procedure ReturnCursor(pCursor OUT RetCursor,c_mask IN char);
>END;
>
>CREATE OR REPLACE PACKAGE BODY GetPermits AS
>
>Procedure ReturnCursor(pCursor OUT RetCursor, c_mask in char) is
>Begin
> open pCursor for select * from permits where permit_num = c_mask;
>End;
>
>END;
>The error message is: PLS-00103: Encountered the symbol "CREATE"
>
>From the Oracle Docs:
>
>PLS-00103: found str but expected one of the following: str
>
>Cause: This error message is from the parser. It found a token (language element) that is inappropriate in this context.
>
>Action: Check previous tokens as well as the one given in the error message. The line and column numbers given in the error message refer to the end of the faulty language construct.
>
>Well ain't that helpful! Anyone see the error of my ways here? TIA!
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao