Re: Passing PL/SQL tables in formal parameter list

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" <dmorgan_at_exesolutions.com> wrote in message news:3D7CFED9.3A2734C_at_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
>
Received on Mon Sep 09 2002 - 15:19:07 CDT