PL/SQL (MOSC)

MOSC Banner

Assigning VARCHAR2 to CLOB : Issue

edited Feb 23, 2016 7:55AM in PL/SQL (MOSC) 5 commentsAnswered

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">';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center