Hi,

1) Is it possible to create a sql loader control file and call sql loader from within a oracle stored procedure. Basically, this procedure will take filename,filepath, file delimiter and table name, schema name as in parameters. It should then create the control file from within the procedure and call sql loader to load the table.

2) In general, is it possible to write unix commands for moving a file or copying a file from within stored procedures by taking the file name and file paths as in parameters to the stored procedures.

Thanks,
Sandya