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.