« AMCharts | Main | Perl Notes (2)-- Array Operators and Functions »
March 10, 2010
wierd dbms_lob.session error
I got this error when I was tring to parse the value from one varchar column and save it into another blob column. Here is the code:
dbms_lob.createtemporary(temp_blob,true,dbms_lob.call);
tempraw:= utl_raw.cast_to_raw(v_summary);
dbms_lob.writeappend(temp_blob,length(v_summary),tempraw);
update tablename
set summary2=temp_blob
where report_id=i.report_id;
commit;
and it gave me an error:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.DBMS_LOB", line 826
ORA-06512: at "SECURITY.TEST", line 14
ORA-06512: at line 22
_--------------------------------------------------------_
ORA-6502 mostly occurs during execution of code in an oracle database due to a bug in the SQL or PL/SQL code. The primary reason this oracle error occurs is when you try to assign a value to a numeric variable but the value is larger than the variable can handle. ORA-06502 oracle error also occurs if you are trying to assign a non-numeric value to a numeric variable
Posted by chenz at March 10, 2010 9:59 AM