Small procedure and bulk collect
Hi all,
I'm not into PL/SQL so I'm reviewing manual to solve a problem. Have to create a procedure that:
select a,b from table (returns multiple lines)
for each returned rowhave to execute a statement
a and b are just numbers.
Looking at manual the SELECT INTO will keep only last value if multiple rows are returned, the SELECT BULK COLLECT INTO force me to use a userdefined data type...
Probably i'm struggling with a real small problem...
Any hint?
Thanks a lost
S.