Assigning VARCHAR2 to CLOB : Issue
Hi All
I am trying to assign my values from a Cursor which are VARCHAR2 and NUMBER to a CLOB variable
But am getting the below error
Cause: FDPSTP failed due to ORA-06502: PL/SQL: numeric or value error
Below is my sample code where the above error is thrown:
v_mesg_body is CLOB and all the other variables like v_po_number, v_line_num , v_shipment_num are all variable from Cursor and where
v_po_number is po_headers_all.segment1%TYPE etc
Code:-
-------------
PROCEDURE gecm_create_mesg_body_prc
IS
BEGIN
v_mesg_body := v_mesg_body || '<tr><td width="5%" align="right"><font size="2">' || v_cnt || '</font></td><td width="10%" align="right"><font size="2">';