-
how to call a sql loader from a pl/sql stored procedure
-
I have been facing the same kind of problem, but to call a sql script fron a pl/sql procedure and I don't think there is a way now to call host programs from within a pl/sql procedure. If its a simple sql query, you can try the HOST command.
HOST ......<command that run on the OS>
Or maybe writing a C++ or Pro*C or a PERL program for that might help. In case that you do find a solution or anyone has a solution, could you please mail the solution to me at mayur_nath@hotmail.com
- Mayur.
-
In Oracle 8 you can use external procedures, in Oracle 7 you can use DBMS_PIPE and Pro*C.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|