problems accessing nested table in proc

From: <dan_at_nospam.com>
Date: 15 Feb 2001 16:17:48 GMT
Message-ID: <96gvfc$po$1_at_news.netmar.com>


Hi,
I am trying to acces a nested table that was passed in as a parameter to a procedure in Oracle 8.1.6. I believe that I am following the examples that are posted on Oracle's site and these news groups, but i am getting the following errors:

Line # = 4 Column # = 1 Error Text = PL/SQL: SQL Statement ignored Line # = 10 Column # = 15 Error Text = PLS-00201: identifier 'INH' must be declared

The create for the objects are as follows.
-- create table type

CREATE OR REPLACE TYPE "SCOTT"."IRC_TYPE_NODE_HDR_COMPLEX" AS TABLE OF "SCOTT"."IRC_NODE_HEADER_ROW"
-- create object type

CREATE OR REPLACE TYPE "SCOTT"."IRC_NODE_HEADER_ROW" AS OBJECT ( "TEST_COL_1" VARCHAR2(255), "TEST_COL_2" VARCHAR2(255), "TEST_COL_3" INTEGER )
-- create proc that receives table type as param
CREATE OR REPLACE PROCEDURE "SCOTT"."TEST-PLEASE-DELETE" (inh IN IRC_TYPE_NODE_HDR_COMPLEX)
as
begin
insert into brandnewtest
(col1, col2, col3)

select nt.test_col_1, 
       nt.test_col_2, 
       nt.test_col_3
from THE(select irc_node_header_row 
         from inh
         ) nt

;
end;
  • Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net
Received on Thu Feb 15 2001 - 17:17:48 CET

Original text of this message