Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2002
    Location
    Sthlm, Sweden
    Posts
    1

    Wink Unanswered: Spawning an Oracle SQL*Loader from a windows app.

    I've got a problem which puzzles me quite a lot... By basic issue that I need to call the SQL*Loader (sqlldr.exe) from a windows application written in Delphi.

    The thing is, if I write a .BAT file which triggers the loading it works fine from the Windows command prompt but if fails when I try calling the batfile from Delphi (using WinExec, CreateProcess or ShellExecute function).

    The error I get is that it gives me a ORA-01461, i.e. it doesn't like my variables ... I mean, sqlldr.exe is actually triggered with the correct parameters in both cases, but why does it fail when triggered from an application ?!?

    Any ideas appreciated.

    BTW, I use Win XP, Oracle 8.1.7, and Delphi 6 Enterprise.

    BR // Niklas

  2. #2
    Join Date
    Apr 2014
    Posts
    5
    I have the same problem and not resolve it.
    Did you have resolve it?

    thanks in advance

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    [oracle@localhost ~]$ oerr ora 1461
    01461, 00000, "can bind a LONG value only for insert into a LONG column"
    // *Cause:
    // *Action:

    do NOT use LONG column datatype
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  4. #4
    Join Date
    Apr 2014
    Posts
    5
    Thanks for the replay.

    Actually the error I get when I run the bat from delphi application with shellexecute is a "2100 RDBMS not found"

    Any idea is appreciated?

  5. #5
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    Quote Originally Posted by olanic View Post
    Thanks for the replay.

    Actually the error I get when I run the bat from delphi application with shellexecute is a "2100 RDBMS not found"

    Any idea is appreciated?
    That is not an Oracle error, you may get your answer if you post the question in the Delphi forum.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •