Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Passing a PL/SQL Table to a procedure
Hello,
I have the following section in my program:
PROCEDURE1
is
TYPE FnameTabTyp IS TABLE OF dbtable.first_name%TYPE
INDEX BY BINARY_INTEGER; fname_tab FnameTabTyp;
begin
/* get values into fname_tab */
procedure2(fname_tab);
end;
PROCEDURE2 (fname_tab IN FnameTabTyp)
is
.............
end;
When I compile the above program, I get the error message:
PLS-00306: wrong number or types of arguments in call to
'PROCEDURE2' What am I doing wrong here? Any suggestions are welcome.
Please send responses to:
nagaraj_jyothi_at_isus.emc.com
Thanks,
Jyothi
Received on Wed Sep 24 1997 - 00:00:00 CDT