My Oracle Support Banner

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

Last updated on NOVEMBER 22, 2019

Applies to:

PL/SQL - Version and later
Information in this document applies to any platform.
***Checked for relevance 23 Apr 2018***


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:




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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