From: "Michael J. Moore" Newsgroups: comp.databases.oracle.server Subject: Passing PL/SQL tables in formal parameter list Lines: 30 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Message-ID: NNTP-Posting-Host: 12.234.158.148 X-Complaints-To: abuse@attbi.com X-Trace: sccrnsc02 1031593199 12.234.158.148 (Mon, 09 Sep 2002 17:39:59 GMT) NNTP-Posting-Date: Mon, 09 Sep 2002 17:39:59 GMT Organization: AT&T Broadband Date: Mon, 09 Sep 2002 17:39:59 GMT How can I define a STAND ALONE procedure to have a PL/SQL table in it's formal parameter list? I tried this .... I understand WHY it is not working, but what do I need to do to accomplish the intended result?: ---------------------------------------------------------------------------- ------------------------ SQL> CREATE or REPLACE PROCEDURE Test1(v_Tab1 OUT t_Tabtype) AS 2 3 TYPE t_Tabtype IS TABLE OF VARCHAR2(20) 4 INDEX BY BINARY_INTEGER; 5 6 v_Tab1 t_Tabtype; 7 8 BEGIN 9 null; 10 END Test1; 11 / Warning: Procedure created with compilation errors. SQL> show errors Errors for PROCEDURE TEST1: LINE/COL ERROR -------- ------------------------------------------------------ 0/0 PL/SQL: Compilation unit analysis terminated 1/28 PLS-00201: identifier 'T_TABTYPE' must be declared