Package Compilation Problem

From: Quantarc <info_at_quantarc.co.uk>
Date: Tue, 29 Jun 2004 15:16:02 +0100
Message-ID: <3QeEc.721$Fc7.169902@stones.force9.net>

Hi, i'm using oracle 9.2.0.1.0, and am trying to create a package, here's a snippet...

open mycur for

     select *
     from "OPS_HD_MAIL";

when i try to compile the package i get the following errors...

  Line # = 14 Column # = 2 Error Text = PL/SQL: SQL Statement ignored   Line # = 15 Column # = 7 Error Text = PL/SQL: ORA-06552: Compilation unit analysis terminated ORA-06553: PLS-320: the declaration of the type of this expression is incomplete or malformed

i tried it with and without the quotes around the table name. now if i change the name of OPS_HD_MAIL to any other table in the database it compiles the package body fine, i even tried creating a synonym to the table and using that but i get the same errors.

i am quite new to oracle, i'm probably missing something obvious? i hope? i couldn't find anyone else having the same problem...

here is the text for the entire package...

---

• START PACKAGE

  ---

create or replace package INTRANET as

• type for returning recordsets type MYCUR is ref cursor;

     procedure SP_INET_GET_UNREAD_MESSAGES( p_request_num number, mycur OUT MYCUR ); end INTRANET;
/

create or replace package body INTRANET as

--

• SP_INET_GET_UNREAD_MESSAGES
  --
  

procedure SP_INET_GET_UNREAD_MESSAGES (

     p_request_num number,
     mycur OUT MYCUR

)
is begin

open mycur for

     select *
     from OPS_HD_M;

end SP_INET_GET_UNREAD_MESSAGES;

end INTRANET;
/

---

• END PACKAGE

  ---

any help would be appriciated.
rod. Received on Tue Jun 29 2004 - 09:16:02 CDT