Re: No errors shown after Compiled with errors message

Aleksey Burdakov wrote:
>
> 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;
>
> /

Well, If I had to guess (which I am),

1. Did you create a package specification?
2. Does the user running this have the correct permissions?
3. Is there a syntax error using `"` characters around the username and package name? -- Ron Reidy Oracle DBA Reidy Consulting, L.L.C.