OraFAQ Forum: Server Administration » a problem of dbms

Home » RDBMS Server » Server Administration » a problem of dbms_job.submit

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

a problem of dbms_job.submit [message #52867]

Sun, 18 August 2002 21:21

hbqwin
Messages: 5
Registered: August 2002

Junior Member

hi,all.
Now,I want to submit a procedure with parameters to the job queue.for example:
dbms_job.submit(job,'procAddSysUser('||sysAcct||','||sysPwd||','||privlg||');',sysdate,'sysdate+(2/(24*60))');
but it failed.
the procAddSysUser is stored procedure,and sysAcct,sysPwd,privlg is his parameter,and the parameter's value is dynamic.

how can i do? please suggest to me!

Report message to a moderator

Re: a problem of dbms_job.submit [message #52875 is a reply to message #52867]

Mon, 19 August 2002 04:14

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

the correct syntaxt would be
[code]dbms_job.submit(job,':procAddSysUser('||sysAcct||','||sysPwd||','||privlg||');',sysdate,'sysdate+(2/(24*60))');
[code]

add a ':' before the procedure name that is supposed to be scheduled.

Report message to a moderator

Re: a problem of dbms_job.submit [message #52889 is a reply to message #52875]

Mon, 19 August 2002 05:37

hbqwin
Messages: 5
Registered: August 2002

Junior Member

now,the job can be submitted.
but procAddSysUser(the procedure) could not be executed
successfully.
I check the what parameter of user_job view,it is ':procAddSysUser(myFin32,myFin32,1000);'

I doubt that it execute the :procAddSysUser but not
procAddSysUser.

how to resolve?

Report message to a moderator

Re: a problem of dbms_job.submit [message #52929 is a reply to message #52875]

Wed, 21 August 2002 00:58

Rajesh Naik
Messages: 6
Registered: January 2002

Junior Member

Put your Procedure in a package

Report message to a moderator

Previous Topic:	CPU 100%.for a database ....and never ends......Why this happens........
Next Topic:	Re: FREE ORACLE ILT BOOKS(oracle university)with OCP KITS.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 12:47:47 CDT 2024