Passing a PL/SQL Table to a procedure
From: Pravin Sitaram <ink_at_tiac.net>
Date: 1997/09/24
Message-ID: <01bcc8fc$d649b600$f20d77ce_at_pravin>#1/1
Date: 1997/09/24
Message-ID: <01bcc8fc$d649b600$f20d77ce_at_pravin>#1/1
Hello,
[Quoted] 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 CEST