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
vz86mj
Messages: 6
Registered: May 2007
Junior Member
Hi,

Please help me to pass the main variable to dbms_job.

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

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,
Sreejit
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: 64151
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||''');');

Regards
Michel


Previous Topic: how to append the rows
Next Topic: UTL_SMTP Package Body
Goto Forum:
  


Current Time: Fri Dec 09 17:36:21 CST 2016

Total time taken to generate the page: 0.35432 seconds