Re: Passing a PL/SQL Table to a procedure

The scope of FnameTabTyp is strictly within procedure1. Either define the type at a level global to procedure1 & 2, or move procedure2 to within procedure1.
- Dan Clamage dclamage_at_idcomm.com

Pravin Sitaram <ink_at_tiac.net> wrote in article <01bcc8fc$d649b600$f20d77ce_at_pravin>...
> 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 CEST