dbms_job.submit vs. too much red wine

[Horace]

Still recovering from last night........
Why doesn't this work....

VAR jobno NUMBER
BEGIN
dbms_job.submit(:jobno,
'TOOLS.HOUSEKEEP',
'NEXT_DAY(TRUNC(SYSDATE), ''SATURDAY'')'
);
END;
/

ERROR at line 6:
ORA-01858: a non-numeric character was found where a numeric was expected
ORA-06512: at line 2

[pando]

next_date is DATE, doesnt need ''

[jovery]

The day doesn't need double quotes, try single quotes instead

Regards

[pando]

jovery you dont need quotes at all for DATE datatype....

[Horace]

I need coffee............
and further help I'm afraid

--------------------------------------------------------------------

Wrote file afiedt.buf

1 BEGIN
2 dbms_job.submit(:jobno,
3 'TOOLS.HOUSEKEEP',
4 'NEXT_DAY(TRUNC(SYSDATE), 'SATURDAY')'
5 );
6* END;

'NEXT_DAY(TRUNC(SYSDATE), 'SATURDAY')'
*
ERROR at line 4:
ORA-06550: line 4, column 43:
PLS-00103: Encountered the symbol "SATURDAY" when expecting one of the following:
. ( ) , * @ % & | = - + < / > at in is mod not range rem =>
.. <> or != or ~= >= <= <> and or like
between ||
The symbol ". was inserted before "SATURDAY" to continue.

------------------------------------------------------------------

Wrote file afiedt.buf

1 BEGIN
2 dbms_job.submit(:jobno,
3 'TOOLS.HOUSEKEEP',
4 NEXT_DAY(TRUNC(SYSDATE), "SATURDAY")
5 );
6* END;

NEXT_DAY(TRUNC(SYSDATE), "SATURDAY")
*
ERROR at line 4:
ORA-06550: line 4, column 41:
PLS-00201: identifier 'SATURDAY' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored

---------------------------------------------------------------

[pando]

use single quotes for DAY

I missread your post jovery, make a pardon!

[Horace]

I did, I think, look at the first error message in the 2 above =[

[pando]

I dont know why it works for me?

SQL> BEGIN
  2   dbms_job.submit(:jobno,
  3   'ANALIZAR_BBDD;',
  4   NEXT_DAY(TRUNC(SYSDATE), 'SATURDAY')
  5   );
  6   END;
  7  /

PL/SQL procedure successfully completed.

[Sameer]

Originally posted by Horace
Wrote file afiedt.buf

1 BEGIN
2 dbms_job.submit(:jobno,
3 'TOOLS.HOUSEKEEP',
4 'NEXT_DAY(TRUNC(SYSDATE), 'SATURDAY')'
5 );
6* END;

'NEXT_DAY(TRUNC(SYSDATE), 'SATURDAY')'

Why do you need these quotes marked as BOLD??? remove those..

[Horace]

1 BEGIN
2 dbms_job.submit(:jobno,
3 'TOOLS.HOUSEKEEP(30);',
4 NEXT_DAY(TRUNC(SYSDATE), 'SATURDAY')
5 );
6* END;


PL/SQL procedure successfully completed.


I think it was the missing parameter for the housekeep function.
Thanks for the input guys.