Alias is confused when the table name and the owner are the same

[Joachim F]

Seems that I've found some tricky thing with aliases...

I give an example, it's easier:

I connect with user DEV, who have the necessary grants to see all the tables in the schema CUSTOMER.
Inside that owner CUSTOMER, there is a table CUSTOMER.

select * from CUSTOMER.CUSTOMER c
where c.

There, the pop-up doesn't come with all the fields. But it works for any other tables... Something wrong in the code?

Thanks in advance! ^^

 

[Marco Kalter]

Can you let me know which PL/SQL Developer version you are using, and what the Oracle Server version is?

 

[Joachim F]

PL/SQL : 8.0.1.1152 and I've also tried with the last version downloaded on the website.

Oracle: 11.2.0.1.0 and I've also tried on 10.2.0.1.0, it's the same...

Thank you!!

 

[vlevi]

As far as I know, the 10.2.0.1.0 and 11.2.0.1.0 Oracle version has a lot of bugs. Corrupted SGA, and so on. We have experienced a lot of problems with these versions. Not only with PL/SQL Developer, but with any software, we tried. Upgrade to 10.2.0.4.0 and 11.2.0.2.0 if you can.

 

[Joachim F]

Thanks for the update!

We've just patched a database recently, to 10.2.0.4.0, and I've done the test right now... Same problem, unfortunately... :-(