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. 04-15-2010 #1
    OKOSAM
    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. Get a Free Complementary Copy of Oracle Magazine and other Free Magazines.
  3. 04-15-2010 #2
    rajavu's Avatar
    rajavu
    rajavu is offline Forum Guru
    Points: 10,800, Level: 68
    Join Date
    13 Oct 2008
    Location
    @ Bangalore , India
    Posts
    814
    Points
    10,800

    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.
« SQL Query : Solution required | Ora-02085 »
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, 08:00 PM
  3. procedure calling procedure using object type reg
    By laxman in forum SQL PL/SQL
    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