Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> No errors shown after Compiled with errors message
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
![]() |
![]() |