SQL & PL/SQL

Hi All,

I am facing
<ORA-23319: parameter value "SYSDATE +,000347222222222222222222222222222222222222" is not appropriate>

issue while submitting job. My nls_lang is set to DUTCH.

below is the declare block:
---------------
DECLARE
job NUMBER;
m_sleeptimegap NUMBER;
job_interval VARCHAR2(100);


BEGIN
SELECT to_number(tdvalue)
INTO m_sleeptimegap
FROM tableconfig
WHERE tcidcode = 'LICENSE_PULSE'
AND tckey = 'STATUS_DELAY';

job_interval := 'SYSDATE +'|| m_sleeptimegap / 86400;

DBMS_JOB.SUBMIT(job, 'License_Pulse_Check;', SYSDATE, job_interval, FALSE);
UPDATE tableconfig
SET tcvalue = LTRIM( RTRIM( TO_CHAR(job) ) )
WHERE tcidcode = 'LICENSE_PULSE'
AND tckey = 'ORACLE-JOB-ID';
COMMIT;
END;
/
----------------

job_interval = SYSDATE +,000347222222222222222222222222222222222222

job_interval variable is causing a problem. if i replace comma with dot using REPLACE function for that variable it works fine. Or if i set NLS_NUMERIC_CHARACTERS to '. ' then to it works fine.

this issue is not coming when my nls_lang=AMERICA then i dont need to set any parameter.

So how should i handle this issue if i have my nls_lang is other than AMERICA. If possible provide some refrence link.

Thanks,