Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why would this error occur?
Message
From
13/12/2001 04:28:32
 
General information
Forum:
Oracle
Category:
Packages
Miscellaneous
Thread ID:
00593313
Message ID:
00593751
Views:
20
For what it's worth....

I usually write it like:



CREATE OR REPLACE PACKAGE GetPermits AS
Type RetCursor Is Ref Cursor;
Procedure ReturnCursor(pCursor OUT RetCursor,c_mask IN char);
END;
/
SHO ERR

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;
/
SHO ERR

Works in SQL Plus and Work Sheet...

Cheers
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform