Friday, March 09, 2007

Apex SQL Command funny notification message

A short note just to mention a sort of bug in Apex.

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:

yes you can!

Two great ways to help us out with a minimal effort. Click on the Google Plus +1 button above or...
We appreciate your support!

latest articles