Very Urgent !!!

[sandya]

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

[pando]

1. there are a couple done, check http://osi.oracle.com/~tkyte/flat/index.html
and
http://www.evdbt.com/unload.sql

2. Executing OS commands needs to be done either from external procedures written in C (UNIX) or write a Java Stored Procedure to execute OS commands and from your PL/SQL procedure you can call this Java Proc to run OS commands, if you are using 8i Java would be easier since external procedures needs listener configuration and a seperate UNIX process (the procedure daemon). I think AMAR posted one Java Stored Procedure in the forum, search "Java" by Amar may be you can find it