From owner-oracle-l@CCVM.SUNYSB.EDU Mon Mar 13 17:45:52 1995 Received: from ccvm.sunysb.edu by alice.jcc.com; (5.65/1.1.8.2/01Aug94-0142PM) id AA10629; Mon, 13 Mar 1995 17:45:42 -0500 Message-Id: <9503132245.AA10629@alice.jcc.com> Received: from CCVM.SUNYSB.EDU by CCVM.sunysb.edu (IBM VM SMTP V2R2) with BSMTP id 5708; Mon, 13 Mar 95 17:31:29 EST Received: from CCVM.SUNYSB.EDU (NJE origin LISTSERV@SBCCVM) by CCVM.SUNYSB.EDU (LMail V1.2a/1.8a) with BSMTP id 1375; Mon, 13 Mar 1995 17:30:19 -0500 Date: Mon, 13 Mar 1995 17:30:19 -0500 Reply-To: "ORACLE database mailing list." Sender: "ORACLE database mailing list." From: "Craig R. McClanahan" Subject: Re: Help create package X-To: ORACLE-L@CCVM.sunysb.edu X-Cc: ORACLE-L@CCVM.sunysb.edu To: Multiple recipients of list ORACLE-L In-Reply-To: <9503132225.AB14333@perpetua.dat.com> (message from John Carlson on Mon, 13 Mar 1995 14:13:42 -8) X-Orig-Date: Mon, 13 Mar 1995 14:32:36 +0800 >>>>> "John" == John Carlson writes: John> It seems that no one around here uses create package, which John> probably sounds strange to most of you. However, I decided John> to try it and get the following messages: John> Warning: Package created with compilation errors. Warning: John> Package Body created with compilation errors. John> My question is, where are these compilation errors listed? John> I can't find any reference to this in the manual and I don't John> know what is wrong if I can't see what the error is. Or, is John> this another Oracle gotcha and you guess at it until you get John> it right? Try logging in with SQL*Plus and typing the command "SHOW ERRORS". This consults a table that Oracle built containing the error listing for the last module you compiled, complete with line numbers. John> I am trying to create the package using SQLPLUS. I am John> running Oracle v 7.0.16 and PL/SQL V 2.0 on an HP Unix box. John> Any help would be much appreciated. John> Thanks, John Carlson Rocketdyne Division Rockwell John> International Canoga Park, CA ---------- Craig R. McClanahan EMAIL: crm@dat.com DAT Services Phone: 503-643-4331 Beaverton, OR, USA Fax: 503-526-6442