Home » SQL & PL/SQL » SQL & PL/SQL » Not able to compile wrapped package bodies. (oracle 10g, pl/sql developer 7.1.0.1337)
icon5.gif  Not able to compile wrapped package bodies. [message #298521] Wed, 06 February 2008 04:54 Go to next message
salwan13
Messages: 1
Registered: February 2008
Junior Member
Hi All

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)??

ThanksInAdvance!!

--------------------
Keep striking the iron until it's hot!
Re: Not able to compile wrapped package bodies. [message #298536 is a reply to message #298521] Wed, 06 February 2008 05:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Any ideas?

Locks?
Query v$lock and v$session_wait.

Regards
Michel
Re: Not able to compile wrapped package bodies. [message #298560 is a reply to message #298536] Wed, 06 February 2008 06:52 Go to previous messageGo to next message
MarcS
Messages: 312
Registered: March 2007
Location: Antwerp
Senior Member
Quote:
Any ideas?


Maybe you got an & somewhere in your code (or even comment for that matter) and is SQL*Plus just waiting for you to type some info ?
Re: Not able to compile wrapped package bodies. [message #298567 is a reply to message #298560] Wed, 06 February 2008 07:48 Go to previous message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Good idea! Wink

Regards
Michel
Previous Topic: Array in PLSQL
Next Topic: Procedure to create a user (merged)
Goto Forum:
  


Current Time: Wed Dec 07 02:47:18 CST 2016

Total time taken to generate the page: 0.05346 seconds