976505 wrote:post whole content of test.sql file
When trying to run a test script using SQLPLUS, I get the following error message:
insert into addm values (Null, 'a');
ERROR at line 5:
ORA-06550: line 5, column 13:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 5, column 1:
PL/SQL: SQL Statement ignored
Can someone help me to resolve this error?
I appreciate the help!
976505 wrote:the Oracle USER invoking the file does not own the table named ADDM.
for t in 1..4444 loop
insert into addm values (Null,'a');
Remove the COMMIT from the loop and just commit after all of the inserts are done.
insert into addm.addm values (Null,'a');