Re: DBMS_JOBS.SUBMIT - DYNAMIC ???

"jobs" <jobs_at_webdos.com> a écrit dans le message de news: 1168036855.163491.253060_at_42g2000cwt.googlegroups.com...
| I'm trying to do something like the following so that I can call this
| sp from a vb.net/ado.net and it will schedule an oracle sp, however I
| suspect this will not work as DBMS_JOB.SUBMIT is not going to parse
| procname.. How can I do this, and is this even the smartest way to do
| this?
|
| CREATE OR REPLACE PROCEDURE MYJOB_JOB(procname in varchar)
| IS
| jobno number;
| BEGIN
| DBMS_JOB.SUBMIT(jobno,procname,sysdate);
| commit;
| END;
|

Yes this works.
Just a small change:

DBMS_JOB.SUBMIT(jobno,procname||';',sysdate);

Regards
Michel Cadot Received on Sat Jan 06 2007 - 00:31:34 CST