Re: DBMS_JOBS.SUBMIT - DYNAMIC ???

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; Received on Fri Jan 05 2007 - 16:40:55 CST