Oracle stored procedure uses DML statement issues

A few days ago with Oracle write stored procedures, found in stored procedures to write update, insert or DELETE statements will compile errors,

Then inadvertently found a solution,

Add EMP to represent the Scott user, if you create a stored procedure with a Scott user, the table name =emp, so that the stored procedure created can write arbitrary DML statements

However, with the rest of the user logged in, if you log in as normal, although the table name can be written as scott.emp, but the DML statement in the stored procedure is not so recognized, will prompt the table or view does not exist

You can use this notation by logging in SYSDBA.

If you are careful you will find that in different ways to log in, the default table space will not be the same, I use the system test, you can try

Oracle stored procedure uses DML statement issues