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
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;