Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Passing a PL/SQL Table to a procedure

Passing a PL/SQL Table to a procedure

From: Pravin Sitaram <ink_at_tiac.net>
Date: 1997/09/24
Message-ID: <01bcc8fc$d649b600$f20d77ce@pravin>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US