Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> No errors shown after Compiled with errors message

No errors shown after Compiled with errors message

From: Aleksey Burdakov <burdakov_at_vesco.ru>
Date: 21 Sep 2001 10:07:39 -0700
Message-ID: <9292180b.0109210907.3676dd0a@posting.google.com>


I run Oracle 8.1.7 and try to create a package body with the script provided in the bottom of the message.  

Oracle says:

> Warning: Package Body created with compilation errors.

So I ask:

> show errors;

No errors.

A similar situation is in DBA Studio, where an "Invalid" indicator is shown against my package body, but the Error window is empty.

What's up with that ?

Do I need some patch or I simply missused some keywords ?

Best Regards,

Aleksey Burdakov


CREATE OR REPLACE  PACKAGE BODY "SYSADM"."S"        AS
     
	function ISN(str IN varchar2) return number IS
	BEGIN
		IF str IS NULL THEN
		    RETURN 1;
		ELSE
		    RETURN 0;
		END IF;
	END ISN;
  
	function ISN(n IN number) return number IS
	BEGIN
		IF n IS NULL THEN
		    RETURN 1;
		ELSE
		    RETURN 0; 
		END IF;
	END ISN;
 
	function ISN(d IN date) return number IS
	BEGIN
		IF d IS NULL THEN
		    RETURN 1;
		ELSE
		    RETURN 0;
		END IF;
	END ISN;


END S; / Received on Fri Sep 21 2001 - 12:07:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US