PL/SQL (MOSC)

MOSC Banner

Is it possible to know if a package is (already) wrapped?

edited Apr 27, 2009 5:04AM in PL/SQL (MOSC) 3 commentsAnswered ✓
 Hello, I've just written a procedure with wraps a package (whose name is given in input) using dbms_ddl.
So far so good. The problem is that, if you for mistake calls the procedure on the same package
twice, it becomes unusable (it seems that create_wrapped doesn't detect that the source is already wrapped and makes a mess in output).
So I am asking if is there any way to know that a package source (i am reading user_source which doesn't seem to contain this information)
is already wrapped ?
thanks in advance
Bye
Nicola

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center