Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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
![]() |
![]() |