calling sqlloader from pl/sql procedure
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: calling sqlloader from pl/sql procedure

  1. #1
    Join Date
    Jan 2001
    Posts
    3

    Cool

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

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