I am debugging a PL/SQL procedure in SQL Developer 4. One of the parameters to the PL/SQL function is a CLOB. I am attempting to figure out how to setup the CLOB for a 51,000+ character CLOB. However I get a "string literal too long" error message.
P_XMLSTRING := NULL;
P_XMLSTRING => P_XMLSTRING,
P_RESULT_CURSOR => P_RESULT_CURSOR
I've tried to set P_XMLSTRING in various ways - plain single quotes ('abc 123'), using TO_CLOB(), creating new temporary clobs using DBMS_LOB, etc. and I cant seem to get it working.