Code Assistant and current_schema?

[swalker]

Greetings, I'm using PL/SQL Developer 7.1.4.1390.

I noticed that placing this:

ALTER SESSION SET current_schema = SCHEMA;

into my AfterConnect.sql does not work as expected.

Meaning, I can perform selects, etc. without issue, but the Code Assistant still refuses to perform auto-completion unless I specify the schema name first.

I had found a few posts stating that this would be in the final release of 7.1.0, but perhaps there was a miscommunication.

 

[Marco Kalter]

Can you give me an example where it doesn't work?

 

[Bernhard S]

Hello,
looks like this is still not working in the current version 8.0.4.1514 either.

An example:
I connect as system in PSD and have an SQL window open.

When I enter there:

select * from scott.emp e
 where e.

the code assistant gets activated and I get suggestions with all the columns of table emp.

Now I do an

alter session set current_schema=SCOTT;

in the same SQL Window. I'd expect that now I get the same code assistant suggestions already without prefixing the table name in the query:

select * from emp e
 where e.

However that doesn't trigger the code assistant. It will still only show up when prefixing the table as I did before.
There are indeed posts claiming that it should be fixed in a version 7 already. Was this ever fixed or just always postponed to later versions? When will this get fixed for real?