CODEWITHSUNDEEP
plsqloracle11g
Shankar
Shankar

Reputation: 27

Wrapping a Package/procedure in PLSQL using object name

I have a package, which is already created in DB.

How to wrap the package by inputting the object name without inputting the total script?

Upvotes: 0

Views: 3302

Answers (1)

David Aldridge
David Aldridge

Reputation: 52386

You can use DBMS_DDL.Wrap to wrap packages that are n the database, but it requires that you read their definition (using DBMS_Metadata for example) to pass it to the procedure, then take the wrapped output and execute the wrapped create package code (using EXECUTE IMMEDIATE for example).

http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/wrap.htm#BEHGEBGI

Upvotes: 1

Related Questions