if u plan to use a dbms_job to automatically execute ur procedure .

try preparing script in the following lines .
- i guess u are executing a pl/sql procedure which accepts same number of arguments with similar datatype .

SQL> create table xyz
( id varchar2(10) ,
filename varchar2(30) ) ;

SQL> insert all arguments as values into this table .

create procedure automate
cursor c1 is select id , filename from xyz where .... ;
begin
for r1 in c1
loop
Procedure1(r1.id,r1.filename ) ;
end loop ;
end ;

----
automattically submitting the job

declare
x binary_integer;
begin
dbms_job.submit(x, 'begin automate; end;',
sysdate , 'SYSDATE + FREQUENCY ' , FALSE);
commit;
end;



DOES THIS ANSWER UR QUESTION ??

CHECK SYNTAX