Re: Passing PL/SQL tables in formal parameter list

"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:05:23 CDT