OraFAQ Forum: Forms » cursors and batch files

Home » Developer & Programmer » Forms » cursors and batch files

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

cursors and batch files [message #145529]

Thu, 03 November 2005 12:55

dmack
Messages: 42
Registered: March 2005
Location: TNT

Member

1. can u create a batch file within oracle

2. I am developing a program and have created a program unit that uses a cursor to retrieve specific records. For each record in the cursor i am creating a script for eg.

PROCEDURE deploy_programs IS

dep_script varchar2(1000);

CURSOR rec1 IS
SELECT dep_prog_name, dep_location
FROM temp_location
WHERE :prog_name = dep_prog_name
AND :sl_location_ip = dep_location
AND :v_hd_user = dep_user;

dep_script := ('copy \\systools\data\development\'||a_rec.dep_prog_name ||' \\128.1.80.49\test');
host(dep_script,no_screen);

The problem is i want to create a batch file to run the process instead. However the batch file works fine if i copy the same script but insert the actual file name instead of (||a_rec.dep_prog_name ||).I need the batch file to use the records retrieved from the cursor. Is that possible?

Report message to a moderator