Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why would this error occur?
Message
 
General information
Forum:
Oracle
Category:
Packages
Miscellaneous
Thread ID:
00593313
Message ID:
00593388
Views:
19
This message has been marked as the solution to the initial question of the thread.
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.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform