ORA-06550: line 1, column 7: PLS-00905: object MCP.MYPROC3 is invalid ORA-06550: line 1, column 7: PL/SQL: Statement ignored
The other approach is to verify that the table exists before executing this portion of the code in your PL/SQL block. Such code might look like the following:
SELECT COUNT(*) INTO num_tables FROM dba_tables WHERE table_name='MY_TABLE'; IF num_tables > 0 THEN INSERT INTO my_table VALUES (.....); END IF;In the above code sample, the INSERT statment only occurs if the table exists. If the table does not exist, the INSERT statement is not executed.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.