Sqlldr and procedure

in Oracle Database; Hi all, how can i invoke sqlldr from a stored procedure: Thanks...
+ Post Reply + Post New Topic
Results 1 to 2 of 2
  1. #1
    OKOSAM is offline Junior Member
    Points: 30, Level: 1
    Join Date
    15 Apr 2010
    Posts
    1
    Points
    30

    Sqlldr and procedure

    Hi all,
    how can i invoke sqlldr from a stored procedure:

    Thanks


  2. #2
    rajavu's Avatar
    rajavu is offline Forum Guru
    Points: 10,830, Level: 68
    Join Date
    13 Oct 2008
    Location
    @ Bangalore , India
    Posts
    815
    Points
    10,830

    Re: Sqlldr and procedure

    To call SQL*Loader you must call the external executable, so you need either Java or some external procedures.

    But the best solution will be to use External tables. EXTERNAL TABLES

    Raj.

Other Solutions
  1. How to solve this procedure
    By Puru in forum SQL PL/SQL
    Replies: 2
    Last Post: 11-10-2010, 03:42 AM
  2. how to getback a procedure
    By kishore garlapati in forum SQL PL/SQL
    Replies: 1
    Last Post: 10-19-2010, 09:00 PM
  3. Replies: 2
    Last Post: 01-13-2010, 04:21 AM
  4. Need some help with a procedure I'm having trouble with
    By tastybrownies in forum SQL PL/SQL
    Replies: 5
    Last Post: 12-01-2009, 07:00 AM
  5. Stored Procedure
    By yashk111 in forum SQL PL/SQL
    Replies: 5
    Last Post: 11-10-2009, 01:26 PM