Home » SQL & PL/SQL » SQL & PL/SQL » Help need for DBMS_JOB
Help need for DBMS_JOB [message #242588] Mon, 04 June 2007 04:14 Go to next message
Messages: 6
Registered: May 2007
Junior Member

Please help me to pass the main variable to dbms_job.

V_name varchar2(30) := 'VZ86MJ';
V_job binary_integer;
-- I have a procedure MY_PROC (v_name varchar2(30))
Dbms_job.submit ( v_job,'MY_PROC(V_name);');

I am getting following error:
ERROR at line 1:
ORA-06550: line 1, column 107:
PLS-00201: identifier 'v_name' must be declared
ORA-06550: line 1, column 93:
PL/SQL: Statement ignored
ORA-06512: at "SYS.DBMS_JOB", line 79
ORA-06512: at "SYS.DBMS_JOB", line 136
ORA-06512: at line 5

Can anybody help me how to pass a variable from a proc to dbms_job?

Thanks and Regards,
Re: Help need for DBMS_JOB [message #242609 is a reply to message #242588] Mon, 04 June 2007 06:01 Go to previous message
Michel Cadot
Messages: 65155
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read and apply How to format your posts
Please always post your Oracle version (4 decimals).

Dbms_job.submit ( v_job,'MY_PROC('''||V_name||''');');


Previous Topic: Hi
Next Topic: How to generate SQL query
Goto Forum:

Current Time: Wed Aug 23 18:28:43 CDT 2017

Total time taken to generate the page: 0.01851 seconds