ORA-00000 normal, successful completion

The ORA-00000 normal, successful completion in Oracle means there is no error in SQL Queries or whatever transactions performed are successful. You can simply ignore this message.

As per Oracle error message guide,

Cause: An operation has completed normally, having met no exceptions.

Action: No action required

Let’s reproduce it,

Create an anonyms block as shown below.

DECLARE
    l_value VARCHAR(30);
BEGIN
    SELECT 1
      INTO l_value
      FROM dual;

    dbms_output.put_line('Error ' || sqlerrm);
END;

It runs a query against the dual table and prints the value of SQLERRM using dbms_output.put_line procedure.

Run it to reproduce ORA-0000.

Error ORA-0000: normal, successful completion

Solution,

Ther is no error here. Whatever query we ran was successful, hence Oracle responds back with ORA-0000: normal, successful completion and stores this value in SQLEEM. Just ignore the error.