From owner-oracle-l@CCVM.SUNYSB.EDU Mon Mar 13 19:57:55 1995 Received: from ccvm.sunysb.edu by alice.jcc.com; (5.65/1.1.8.2/01Aug94-0142PM) id AA04688; Mon, 13 Mar 1995 19:57:52 -0500 Message-Id: <9503140057.AA04688@alice.jcc.com> Received: from CCVM.SUNYSB.EDU by CCVM.sunysb.edu (IBM VM SMTP V2R2) with BSMTP id 6018; Mon, 13 Mar 95 19:39:17 EST Received: from CCVM.SUNYSB.EDU (NJE origin LISTSERV@SBCCVM) by CCVM.SUNYSB.EDU (LMail V1.2a/1.8a) with BSMTP id 2307; Mon, 13 Mar 1995 19:38:43 -0500 Date: Mon, 13 Mar 1995 14:56:47 PST Reply-To: "ORACLE database mailing list." Sender: "ORACLE database mailing list." From: Jim Collings Subject: Re: Help create package X-To: "ORACLE database mailing list." To: Multiple recipients of list ORACLE-L 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." 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