Quote Originally Posted by pando
I am saying your data contains characters, are you sure your data comes clean?
Mr. Pando in my temp table i am storing data in varchar2 format whether it comes number or string but error comes when it goes for bulk collection, whatever datatype of my procedure's variables has been selected in that query is same as table's datatype.

i.e. DUAL_IMSI_FLAG varchar2(20) contains numeric value.In my procedure i have declare it like below.

TYPE s19 IS TABLE OF customer_rec.DUAL_IMSI_FLAG%TYPE INDEX BY BINARY_INTEGER;

V_DUAL_IMSI_FLAG S19;

if it is issue of numeric value to be inserted/selected in varchar2 value than it comes when it is inserting record. but it is showing me when i m selecting it.i m not changing its datatype in my procedure.

dhaval