Hi ,
I have a dellimited .dat file and a sqlloader.
I want to call the sqlloader from a oracle stored procedure.
The procedure should return the result of sqlloader's execution.
This does not sound like a great idea.
However - One way.
Oracle provides you the option of writing small or large C programs that live in external libraries, and are accessed by the Oracle kernel via a listener. You could wirte a small Pro*C program that makes a system() call to invoke sqlldr.
Here is a general overview of the idea. It references dll's (Windows files) but you can link and create libraries on UNIX just the same, or search ORAFAQ for more information.
Jim Appreciate your answer.
Is there no way where in I want to write into the table using the UTL package?
Could you please suggest something in oracle package itself?
Thanks-Ann:)
UTL_FILE lets you open the file.
What you really want is an external table, I think.
External Tables | Oracle FAQ