Re: Help create package

From: NAME: Bruce Pihlamae

        FUNC: Information Services
        TEL: (06) 289-7056 <PIHLAMAE BRUCE_at_A1@CBR>
To:     MX%"ORACLE-L_at_CCVM.SUNYSB.EDU"@CNB09W_at_MRGATE@CBR
CC:     MX%"jecarlso_at_WINDANCE.RDYNE.ROCKWELL.COM"@cnb09w_at_mrgate@mrgate

> Sender: "ORACLE database mailing list." <ORACLE-L@CCVM.SUNYSB.EDU>
> From: John Carlson <jecarlso_at_WINDANCE.RDYNE.ROCKWELL.COM>
> Organization: Rocketdyne
> Subject: Help create package
> X-To: ORACLE-L_at_ccvm.sunysb.edu
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_CCVM.SUNYSB.EDU>
>
> It seems that no one around here uses create package, which probably
> sounds strange to most of you. However, I decided to try it and get
> the following messages:
>
> Warning: Package created with compilation errors.
> Warning: Package Body created with compilation errors.
>
> My question is, where are these compilation errors listed? I can't
> find any reference to this in the manual and I don't know what is
> wrong if I can't see what the error is. Or, is this another Oracle
> gotcha and you guess at it until you get it right?

Have a look at the SHOW ERRORS command

I use it as

   create or replace object_type object_name AS etc;

      {where object_type = package or package body or procedure}

   show errors object_type object_name

Good luck

Bruce... pihlab_at_cbr.hhcs.gov.au Received on Mon Mar 13 1995 - 20:17:23 CST