Re: Passing PL-SQL Tables as arguments

You have to define all types before using them. In Oracle 7 you must define the type in a package which you can then use. Oracle 8 allows for definitions of types in the database itself.

Lloyd Sheen
Sylvain Faust Inc. (SFI)
A Decade of Delivering SQL Solutions, 1988-1998 http://www.sfi-software.com

gundugollu_at_yahoo.com wrote in article <6fr38n$ptn$1_at_nnrp1.dejanews.com>...
> Hi
>
> I am trying to pass a PL-SQL Table to a procedure. I don't know
> if this is possible.
>
> What I am trying to do as a first step is declare a procedure
> with the argument as a pl-sql table.
>
> create or replace procedure proc_xx(
> table_in IN products_table)
>
> TYPE products_table IS TABLE OF products
> INDEX BY BINARY INTEGER
>
> BEGIN
> ...
>
>
> I am getting error when I compile this saying
> 0/0 PL/SQL: Compilation unit analysis terminated
> 1/34 PLS-00201: identifier 'PRODUCTS_TABLE' must be declared
>
> Any help/suggestions greatly appreciated
>
> TIA
>
> Anil
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>
Received on Tue Mar 31 1998 - 00:00:00 CEST