problems accessing nested table in proc
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