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!

Looping in Pl/SQl with semicolon separator as adress

1567114Apr 12 2017 — edited Apr 24 2017

i have one cursor defined as cur_serv_hrds which has attribute7 which holds address as abc@xyz.com;def@xyz.com;ghj@xyz.com

is there a way to get into email address of attribute7 in a loop susubstr with respect to instr of ; and fetch to each and every time the xml generates with reply to address

the xml will be generated the number of times the email adresses separated by ;

please help me on this

i have given the packaged code as above

This post has been answered by Gaz in Oz on Apr 14 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 13 2017
Added on Apr 12 2017
13 comments
919 views