Can anybody pls help me finding me the reason why I m not able to compile .plb (wrapped package body). There are no compilation errors. But when I run the .plb file (as @xyz.plb), sqlplus window hangs. No error shown. Everytime I had to close the window after waiting for 8-10 minutes.
This is happening only with 11 files out of 200.Rest were compiled.
Any ideas? Do we have any other way to wrap than using pl/sql wrap utility or pl/sql plug-in for wrapping(which is actually the same as former)??
Keep striking the iron until it's hot!
yes, I did check for locks from pl/sql developer only. No Locks.
I waited for 10 minutes for a 6 kb .plb file to get compiled. But had to close the session after that.
I am using oracle 10g, pl/sql developer 22.214.171.1247
sql*plus Release 10.2.0.2.0