Compilation errors, last time I checked, where placed in the
dba_errors table. When objects are compiled and errors are returned,
they go into this table. I just recompiled a view the other day and
the error message "942" was found there. This should do the trick.
Good Luck,
Jim Collings
Eventus Software, Inc.
Long Beach, CA.
______________________________ Reply Separator _________________________________
Subject: Help create package
Author: "ORACLE database mailing list." <ORACLE-L_at_CCVM.sunysb.edu> at Internet
Date: 3/13/95 2:41 PM
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?
I am trying to create the package using SQLPLUS. I am running Oracle
v 7.0.16 and PL/SQL V 2.0 on an HP Unix box. Any help would be much
appreciated.
Thanks,
John Carlson
Rocketdyne Division
Rockwell International
Canoga Park, CA
Received on Mon Mar 13 1995 - 19:57:55 CST
