joekeri
asked on
How can i pass in a ROWTYPE to an procedure an populate it into an ARRAY?
I have a procedure called A_LOAD and I want to pass a record(%ROWTYPE) it an load the record type into an array.
Table_a is defined as
Empno number
dept number
empname
I want to take all the records beign passed into the procedure and load it into the table. then I want to take the table a FETCH each column from it. I just dont know if i need a CURSOR or not.
ANy help will be appreciated.
Table_a is defined as
Empno number
dept number
empname
I want to take all the records beign passed into the procedure and load it into the table. then I want to take the table a FETCH each column from it. I just dont know if i need a CURSOR or not.
ANy help will be appreciated.
Create or replace procedure A_LOAD
(P_rec_in Table_A%rowtype) is
TYPE C1_record_table is TABLE OF P_REC_IN%rowtype by binary_integer;
C1_REC C1_record_table;
BEGIN
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I undrstand your code, just wonder if i really need to use a package. Coulnt i blend your 3 procedures into a single procedure instead?