CODEWITHSUNDEEP
sqloracle-databaseplsql
Ramin Darvishov
Ramin Darvishov

Reputation: 1039

How to wrap PL/SQL source code in Oracle?

How can I use user defined wrap function or unwrapped method in Oracle? Because default wrapping code is can be unwrapped.

Upvotes: 6

Views: 2597

Answers (2)

wolφi
wolφi

Reputation: 8361

Oracle's documentation says:

Wrapping a PL/SQL unit prevents most users from examining the source code, but might not stop all of them.

If you read Pete Finnigan's analyis of the wrapping mechanism, the wrapped code is just an encoding of the DIANA or Interface Description Languange (IDL) version of your source code. I don't see any way how you can change the wrapping mechanism and still be valid IDL.

After unwrapping, I normally give up if the PL/SQL package calls C functions. So you might try writing C libraries. They seem to be much harder to re-engineer...

Upvotes: 1

Steven Ensslen
Steven Ensslen

Reputation: 1376

Use the wrapped procedure the same way that you use an unwrapped procedure. Call it from SQL or PL/SQL. Wrapping has no effect on calling the run-time behaviour of the stored procedure. The procedure is still in ALL_OBJECTS and its parameters are still in ALL_ARGUMENTS.

Upvotes: 1

Related Questions