Error/feature, viewing SQL for job can be optimised

[Claus Pedersen]

When viewing SQL for a job, the code looks like this:

begin
  sys.dbms_job.submit(job => :job,
                      what => 'do_something',
                      next_date => to_date('15-05-2007 15:44:41', 'dd-mm-yyyy hh24:mi:ss'),
                      interval => 'sysdate + 1/(24*60)');
  commit;
end;
/

The variable :job can of course not be used in a command prompt. Please could the :job variable be replaced by:

declare
  MyJob pls_integer;
begin
  sys.dbms_job.submit(job => MyJob,
                      <...>

Thanks

 

[Marco Kalter]

It works if you use a bind variable.

 

[Claus Pedersen]

Yes, this is true, but I want to cut-and-paste the code directly into a command script that can be run from a command prompt, for instance SQL*Plus.

It is not a big deal, you might want to include in the request list ...