Re: Can I pass the PL/SQL table as an argument

Hi,

Passing a PL/SQL table as an argument is no problem; just make sure that the argument type is available to the procedure. For example, suppose you have a package MyPack with a type definition in the header, like:

TYPE MyType IS TABLE OF MyTable.MyColumn%TYPE INDEX BY BINARY_INTEGER; You can then use this type anywhere define PL/SQL tables and pass them as an argument, for example:

PROCEDURE MyProc
  ( MyPLSQLTable IN OUT MyPack%Mytype)
IS
...etc.

Good luck,

Paul.

sambavan_at_mail.utexas.edu wrote in article <6fcmnc$ld5$1_at_nnrp1.dejanews.com>...
> Hi
>
> Is it possible to pass the PL/SQL table as an argument to a procedure?
> If so what should be the argument type and how should I pass?
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>
Received on Thu Mar 26 1998 - 00:00:00 CST