Re: No errors shown after Compiled with errors message

Your function decralations don't match their definitions.

declarations:
function ISN(str IN number) return number; function ISN(str IN date) return number;

definitions:
function ISN(n IN number) return number IS function ISN(d IN date) return number IS

Just change str into n and d in package specification. Yep, I know, formal parameters names shouldn't matter - just their types should - but its the way pl/sql works.

Regards,
Igor.

burdakov_at_vesco.ru (Aleksey Burdakov) wrote in message news:<9292180b.0109240258.5924fb41_at_posting.google.com>...
> Ron,
>
> 1. Yes, I created the package specification (see in the bottom of the
> posting).
> 2. Well, I have successfully created another package also with SYSADM
> user having DBA permissions. I have tried to create the package
> "SYSADM"."S" under SYS and SYSTEM accounts.
> 3. None it reports of. Another package body created as "SYSADM"."ISN"
> gave no syntax error.
>
> I have also patched my installation, so right at the moment it has
> 8.1.7.2.1 version. The problem persists and it keep not showing any
> error.
>
> Any other ideas ?
>
> Thanks,
>
> Aleksey Burdakov
>
> > 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?
>
> ===========================================================
>
> CREATE OR REPLACE PACKAGE "SYSADM"."S" AS
> function ISN(str IN varchar2) return number;
> pragma restrict_references (ISN, wnds, wnps, rnds, rnps);
> function ISN(str IN number) return number;
> pragma restrict_references (ISN, wnds, wnps, rnds, rnps);
> function ISN(str IN date) return number;
> pragma restrict_references (ISN, wnds, wnps, rnds, rnps);
> END S;
Received on Wed Sep 26 2001 - 01:41:51 CDT