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!

Bulk Collection Exception handling

3133262Dec 3 2015 — edited Dec 7 2015

Hello Guys,

Please help me with a code to fetch data from the table with incorrect data type..

I have a table with the data

Col1(varchar2(10))

--------------------

1001

1002

1003

1004

1006

1007

1009

1010

I need to write a PL/SQL code to bulk collect the data from the above table into a variable (v_num number) except that 'A'. Please let me know how to handle the invalid number exception in this case. I am using oracle 10G

This post has been answered by Ashu_Neo on Dec 4 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 4 2016

Added on Dec 3 2015

14 comments

2,319 views