Question: how to fix ora-00604 error occurred at recursive sql level 1?
Answer: Find the trigger that is causing the problem and disable it or drop it to resolve the issue. Usually, this error occurs in the Oracle database by the system level triggers on DDL or SYSTEM events. Another example of error ORA-00604 is when the user attempts to run a newly-created table using SELECT* from cdc.