Manik wrote:Yes, because of a New line. :)
This one works in Sqlplus..
910575 wrote:As you mention Datatype for Assertion_Id is VARCHAR2(4000) but you have declared the variable as CLOB. Also, If I understand correctly, mentioned in other threads, you are trying to convert the VARCHAR2(4000) to CLOB.
The datatype of assertion_id is varchar2(4000).
procedure gsm_prc(i_assertion_id in clob)
insert into assertion_info (assertion_id) values (i_assertion_id);
to fetch only 4000 bytes and store into your table.
dbms_lob.substr(i_assertion_id, 4000, 1)