PLS-302 When Table Name And Schema Name Are Identical (Doc ID 567376.1)

Symptoms

Attempting to run a SQL statement such as

SELECT scott.scottnr_seq.NEXTVAL into var from dual
in a pl/sql block, where the table and the schema have the same name, raises the error
PLS-00302: component 'SCOTTNR_SEQ' must be declared

The issue can be reproduced at will with the following steps:

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.