Execute immediate in Oracle

It's you. A stored procedure creates a table table_a and then inserts the other data into the table_a with insert into, but because Table_a does not exist when you create the process, the process shows a compile error because table_ A does not necessarily cause the process to fail, so it cannot be compiled successfully, and when the INSERT INTO statement is added to execute immediate, Oracle will no longer ignore the existence of this object, so it can be compiled and executed successfully.

Execute immediate in Oracle