Re: Passing PL/SQL Table into Stored Proc from SQLPlus

create an anonymous pl/sql block.

SQL> declare
  2 fort types.VarcharTableTyp;
  3 fight types.VarcharTableTyp;
  4 begin
  5 foo('initial','2nd',3,fort,fight);   6 end;
  7 /

the previous assumes something similar to the following: SQL> create package types is
  2 type VarcharTableTyp is table of varchar2(2000) index by binary_integer;
  3 end;
  4 /

Gary Friedrichsen wrote:
>
> I have created a Stored Procedure which has 3 scalar input
> parameters, and two PL/SQL Table input parameters. I have been
> unsuccessfull executing this from SQLPlus because I cannot
> find how to pass in the table parameters.
>
> Any help???
 

-- 
______________________
robert mailto:nix_at_gate.net