How to test procedure return multi-rows in SQL-PLUS

From: Tony Yu <tonyyu_at_pathcom.com>
Date: Thu, 25 Nov 1999 22:36:24 -0500
Message-ID: <81l04s$25c$1_at_newsmaster.pathcom.com>

Hi, All
[Quoted] I have a problem with testing procedure which return multi-rows in SQL-Plus.

In SQL-PLUS

declare
type abc is varray(30) of varchar2(20);
begin
pack.person(abc);
end;

[Quoted] I got an error which is "Wrong number or type of arguement". here is package:

package pack as
type cde is table of varchar2(20);
begin
procedure person( cde );
end;

package pack body as
type cde is table of varchar2(20);
begin
proceduer person(cde)
is
  declare
  cursor aa_cur is select aa from person;   percount number :=1;
  begin
    for single_aa in aa_cur loop

       cde(percount) := single_aa.aa;
       percount := percount + 1;

   end loop;
 end;
end ;

Thanks in advance!!!

Tony.
E-mail: tonygyu_at_hotmail.com Received on Fri Nov 26 1999 - 04:36:24 CET