Problem with Schema having a Table with the Same Name as the Schema

[Quantum]

If you have a schema which has a table with the same name as the schema, then executing a procedure will fail if you qualify the procedure with the schema name. Execution is successful only after the table is dropped.
This is what I get:

KT@ETL> select * from tab;

TNAME TABTYPE
---------- -------
KT TABLE
TEST TABLE

KT@ETL> exec kt.salrange (2000, 2500);
begin kt.salrange (2000, 2500); end;

ORA-06550: line 1, column 10:
PLS-00302: component 'SALRANGE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

KT@ETL> drop table kt;

Table dropped

KT@ETL> exec kt.salrange (2000, 2500);
Execution is successful and data is displayed

This symptom is related the one I described in the post:
Auto complete for tables are not happening when we querying other schema objects

Thanks

 

[Marco Kalter]

This ambiguity does indeed seem to cause problems for the Oracle name resolution process.