Database Administration (MOSC)

MOSC Banner

problems ORA-01426: numeric overflow

edited Nov 9, 2010 11:58AM in Database Administration (MOSC) 13 commentsAnswered
  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'')'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center