DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: calling sqlloader from pl/sql procedure

  1. 01-18-2001, 09:11 AM #1
    badari
    badari is offline Junior Member
    Join Date
    Jan 2001
    Posts
    3

    Cool

    how to call a sql loader from a pl/sql stored procedure
    Reply With Quote Reply With Quote
  2. 01-18-2001, 11:36 AM #2
    tmnath
    tmnath is offline Junior Member
    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.
    Reply With Quote Reply With Quote
  3. 01-18-2001, 12:33 PM #3
    akkerend's Avatar
    akkerend
    akkerend is offline Senior Member
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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