HELMUT.DAIMINGER@wwk.de

  • From: Charlotte Hammond <charlottejanehammond@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 18 Jan 2005 03:41:04 -0800 (PST)

Hi Helmut,

Try:

SHOW ERRORS PACKAGE BODY dwhstaging.map_b3000t_ei_a04_b3000t_002 

HTH,

Charlotte

 "Daiminger, Helmut" <HELMUT.DAIMINGER@xxxxxx>
 Sent by: oracle-l-bounce@xxxxxxxxxxxxx
 18/01/2005 10:35
 Please respond to HELMUT.DAIMINGER
   
   To: "LazyDBA.com Discussion" <oracledba@xxxxxxxxxxx>, 
<oracle-l@xxxxxxxxxxxxx>
   cc: 
   Subject: "show errors" when wrapped package does not compile properly


Hi!

We have some packages that were generated by Oracle Warehouse Builder.
The package header has a "valid" status, but the package body is
"invalid".
Using Enterprise Manager, I can't see the source code of the package
body. Seems like it is wrapped.

If I try to compile the package I get this:

SQL> alter  package dwhstaging.map_b3000t_ei_a04_b3000t_002 compile;

Warning: Package altered with compilation errors.

SQL> show errors
No errors.


Is thee a way to find out what going wrong?

This is 9.2 on HP_UX 11i; Warehouse Builder 9.2

Thanks,
Helmut
--
//www.freelists.org/webpage/oracle-l


 


                
---------------------------------
Do you Yahoo!?
 Yahoo! Mail - Helps protect you from nasty viruses.

--
//www.freelists.org/webpage/oracle-l

Other related posts:

  • » HELMUT.DAIMINGER@wwk.de