Re: No errors shown after Compiled with errors message

From: Aleksey Burdakov <burdakov_at_vesco.ru>
Date: 24 Sep 2001 03:58:31 -0700
Message-ID: <9292180b.0109240258.5924fb41@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 Mon Sep 24 2001 - 05:58:31 CDT