Execute immediate, immediate

Execute immediate, immediate

Create a table table_a during the creation of a stored procedure and use insert into to insert other data into table_a. However, because table_a does not exist during the creation process, A compilation error is displayed in the process. Because table_a does not exist, the process cannot be executed, so the compilation is not successful, after the insert into statement is added to execute immediate, oracle does not care whether the object exists, so it can be compiled and executed successfully.