Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Small procedure and bulk collect

user12945439Oct 5 2011 — edited Oct 5 2011
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 2 2011
Added on Oct 5 2011
9 comments
405 views