Plz do abide to our Terms & Condition:

    • Do not paste URL Links directly in any content instead post them as Hyperlink inside a text.
    • To post a Link directly use instead Bookmark.
    • If we find anyone posting beyond the warning we will immediately terminate your account without any warning. 

ORA-0000: normal, successful completion

    Meril Jeffery John.J
    • 0/5 (0 votes)
    Asked by Meril Jeffery John.J Answers (1)

    I am geting this error in Oracle forms & report. ORA-0000: normal, successful completion - ORACLE error: unable to INSERT record. 

    Answers (1)

      • Arun prasad
        By Arun prasad

        Reason(s) for this Oracle error:

                         This error usually occurs when the database is cloned from existing RAC database and this could be normally found in Oracle RAC environment. This is not a consistent error and no proper reason for this and this also occurs while using OCI programming and while using Microsoft ODBC Driver for Oracle.

        Possible steps to solve this error

        1) One way to stop this error was to disconnect the session and start a new session to complete the task, i.e., exit the SQLPLUS editor and start again.
        2) If you receive this error from ASP while connecting to Oracle, check these for resolution steps