Question: Why am I getting Oracle error PL / SQL: ORA - 0 0 9 4 2 : table or view does not exist for this
Why am I getting Oracle error PLSQL: ORA: table or view does not exist for this PLSQL when I have already confirmed that the table exists?
Declare
rowsinserted integer :;
Begin
LOOP
Begin
INSERT INTO employeeemployeeid lastname, departmentid
VALUESempidseq.NEXTVAL, concatEMPLNAMEtocharrowsinserted;
Only increment counter when no duplicate exception
rowsinserted : rowsinserted ;
Exception When DUPVALONINDEX Then Null;
End;
exit when rowsinserted ;
commit;
END LOOP;
End;
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
