Go to SQL Workshop and execute the following statement (supposing you don't currently have already a funny_pkg in your schema, otherwise you'll override it!):
Create or replace
Package Funny_Pkg as
Procedure Test (
par_a in varchar2,
par_b in number);
End Funny_Pkg;
Apex notifies you with the following message
Procedure created.
Now, let's change just a little bit the command, coalescing the first two lines of text:
Create or replace Package Funny_Pkg as
Procedure Test (
par_a in varchar2,
par_b in number);
End Funny_Pkg;
Now you get the following, correct, notification:
Package created.
There must some weird string processing going on behind the scenes if it picks different object types depending on the line position.
It's just a little whim, the object is fine, the package will be there even if it says it created a procedure.
But this will serve as an introduction to the next topic, an evergreen in the realm of Oracle's quirks.
No comments:
Post a Comment