problems ORA-01426: numeric overflow
Hello,
When trying to create a job in the database I get the following error:
ORA-01426: numeric overflow
I tried to create the same job on another database with the same version of the one where I get the error and it creates fine.
Can anyone help me out?
The script that I use to create the job:
--------------
DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X
,what => 'insert into dba.dba_logs values (''SGC'',''TRL03'',sysdate,null);
commit;
'
,next_date => to_date('07-11-2010 02:00:00','dd/mm/yyyy hh24:mi:ss')
,interval => 'NEXT_DAY(TRUNC(SYSDATE)+2/24,''SUNDAY'')'
When trying to create a job in the database I get the following error:
ORA-01426: numeric overflow
I tried to create the same job on another database with the same version of the one where I get the error and it creates fine.
Can anyone help me out?
The script that I use to create the job:
--------------
DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X
,what => 'insert into dba.dba_logs values (''SGC'',''TRL03'',sysdate,null);
commit;
'
,next_date => to_date('07-11-2010 02:00:00','dd/mm/yyyy hh24:mi:ss')
,interval => 'NEXT_DAY(TRUNC(SYSDATE)+2/24,''SUNDAY'')'
0