DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2001


    how to call a sql loader from a pl/sql stored procedure

  2. #2
    Join Date
    Jan 2001
    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.

  3. #3
    Join Date
    Jul 2000
    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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.