sql loader return codes - shell

Posted on 2006-04-04
Last Modified: 2008-02-20
I am executing a sql loader script from within a vbs file utilizing the Object.

x = createObject(
retcode= (sqlloader string)

What are the possible return codes. [Are there any other codes except 0,1,2,3 ]
Any help is appreciated.
Question by:crystalguy2000
    1 Comment
    LVL 4

    Accepted Solution


    You can viisit :

    Exit Codes for Inspection and Display
    Oracle SQL*Loader provides the results of a SQL*Loader run immediately upon completion. Depending on the platform, as well as recording the results in the log file, the SQL*Loader may report the outcome also in a process exit code. This Oracle SQL*Loader functionality allows for checking the outcome of a SQL*Loader invocation from the command line or script. The following load results return the indicated exit codes:

    Result  Exit Code  
    All rows loaded successfully  
    All/some rows rejected  
    All/some rows discarded  
    Discontinued load  
    Command line/syntax errors  
    Oracle errors fatal to SQL*Loader  
    OS related errors (like file open/close, malloc, etc.)  

    For UNIX the exit codes are as follows:

    EX_SUCC      0
    EX_FAIL      1
    EX_WARN      2
    EX_FTL      3


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that useā€¦
    Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now