* This electronic document (comprising text and any attachments)
* is confidential and intended solely for the use of the individual
* or entity to whom it is addressed.
*
* If you have received this document in error please notify the
* System Manager <mailto:[Email Address Removed] Gurus,

create or replace procedure clk as
v_sid number;
v_serial number;
l_string varchar2(200);
v_bkgd number;
v_job number;
j_string varchar2(200);
v_dbname varchar2(10);

begin

select distinct b.job
into v_job
from v$session a,dba_jobs_running b,v$locked_object c,dba_jobs d
where a.sid=b.sid
and a.sid=c.session_id
and b.job=d.job
and upper(d.what) like '%SNAP_REF_WTDSLOTSGROUP%';

dbms_output.put_line('Breaking the job.......');

j_string:='exec dbms_job.broken('||v_job||',true);';

execute immediate j_string;

end;
/

What is wrong in the above line marked in red?

Thanks,
Ravi



**********************************************************************
* P&O Stena Line Ltd disclaims all legal responsibility for the
* accuracy or otherwise of any information contained within this
* electronic document (comprising text and any attachments).
*
* Any view expressed about individuals or other companies is that
* of the originator of the document and in no way represents the
* corporate view of P&O Stena Line Ltd.
*
* This footnote also confirms that the document has been swept
* by MIMEsweeper for the presence of computer viruses.
*
* <http://www.posl.com/>

Oracle LazyDBA home page