From: "Michael J. Moore" Newsgroups: comp.databases.oracle.server References: <3D7CFED9.3A2734C@exesolutions.com> Subject: Re: Passing PL/SQL tables in formal parameter list Lines: 55 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: <%m7f9.421387$UU1.66027@sccrnsc03> NNTP-Posting-Host: 12.234.158.148 X-Complaints-To: abuse@attbi.com X-Trace: sccrnsc03 1031602747 12.234.158.148 (Mon, 09 Sep 2002 20:19:07 GMT) NNTP-Posting-Date: Mon, 09 Sep 2002 20:19:07 GMT Organization: AT&T Broadband Date: Mon, 09 Sep 2002 20:19:07 GMT I am trying to learn what works and what does not work in PL/SQL. I have not been able to find any specific documentation that says this cannot be done, nor have I been able to find an example of how to do it. I have seen it done within a Package where the TYPEs are defined as package variables, but that begs the question, how would a person call that packaged procedure from outside of the package. If I can solve THIS question, I will be able to answer the 'packaged procedure' question implicitly. Thanks, Mike "Daniel Morgan" wrote in message news:3D7CFED9.3A2734C@exesolutions.com... > "Michael J. Moore" wrote: > > > 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 > > Tell us what you are trying to accomplish? Perhaps a PL/SQL table is not the > best solution. > > Daniel Morgan >