OraFAQ Forum: Forms

Home » Developer & Programmer » Forms » cursors

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

cursors [message #139379]

Tue, 27 September 2005 14:33

dmack
Messages: 42
Registered: March 2005
Location: TNT

Member

Hi everyone I need some help
I have a table that contains program names and IP adresses (to facilitate the deployment of programs to diffrent locations)

I need to retrieve these records based on certain criteria from this table namely;

1. user_id
2. program name
3. ip address/location

based on form selection.

When these records are retrieved I need to create a script for the program name selected and for each location to be deployed to.Therefore if there is one program and 5 locations, the script will be written 5 times, eg of script below.

'copy \\servername1\foldername1\foldername2\'|| :prog_name ||' \\'||:location_name.location_ip||'\destination_servername'

I am having problems here:

I think i have to create a cursor to retrieve the records and for each record in the cursor write the script.
I am not sure of the how to write the code ( I have already created the cursor) but not sure how to include for each record in cursor create script.

Can u provide an example or guide me accordingly

This process should be initialised by a button (i am not sure if i have to create a function/procedure or place code under button trigger when-button-pressed.

Also I have to use a host command to complete the deployment process how can this be done form forms 6i.

Thank u

Report message to a moderator