SET IGNORE_SPLCHARS

Use this command to ensure that special character, such as colon, is not used as a bind variable, and carriage returns and spaces in a SQL string are not skipped and gets inserted into the database as it is written in the DMS script.

Syntax

Use the syntax with ON option.

SET IGNORE_SPLCHARS ON;

Example

When this example SQL string is run with ON option, the special character colon is retained as it is and the SQL runs to success.

SET LOG JOE_DMS.LOG; 
SET IGNORE_SPLCHARS ON;
insert into PS_PTIASQLTXTDFN select 'ONEROUTECONTROL3','0','GBL','
',TO_DATE('1900-01-01','YYYY-MM-DD'),'00.00.000','0',30,0,'PS',to_timestamp('2021
-02-1903.20.01.03','YYYY-MM-DD HH24.MI.SS.FF'),'0','CEO',TO_CLOB('SELECT RECNAME
,FIELDNAME ,EOCC_CRITERIA_SYM ,EOCC_VALUE_MATCH , EOCC_FIELD_TYPE FROM 
PS_EOCC_CONFIG_CRT WHERE PNLGRPNAME=:1 AND MARKET = :2 AND SEQUENCE_NUMBER = 
:3 AND EOCC_CONFIG_TYPE = :4

                     ')from dual;