Auto complete for different schema

[Kirill S.]

Hi,

using the following command:
alter session set current_schema=XXXX I can set current ORACLE schema to XXXX and use objects in my code without schema prefix. But auto complete function doesn't work in this case.

A few months ago in forum it was informed that this feature will be included into future enhancements.

Can you provide me with some clarification about this? In what release we can expect this feature to be implemented?

Regards,
Kirill S.

 

[Marco Kalter]

Explicit support for the current_schema session setting is planned for 7.1 later this year.

 

[Kirill S.]

Thank you, Marco. Waiting for 7.1

 

[Kirill S.]

Hi, Marco,

May be, while we are waiting for 7.1 version, there is some work around to make code assistant understand that it should find the objects in different user schema? May be some configuration parameters ?

Regards,
Kirill S.

 

[Marco Kalter]

No, there is no option for this. It will always resolve the names based on the current user, not the current schema.

 

[Kirill S.]

Hi, Marco,

Are the dates for PL/SQL developer version 7.1 release already defined?

Regards,
Kirill

 

[Marco Kalter]

Version 7.1 is planned for the end of this year.

 

[Kirill S.]

Hi, Marco,

What about version 7.1 promised at the end of the year 2006? When we can expect the release?

Regards,
Kirill

 

[Marco Kalter]

We will have a beta this month.

 

[Kirill S.]

Hi,

Is 7.1 betta available ?

Regards,
Kirill

 

[Marco Kalter]

Not yet, it will be this month.

 

[Kirill S.]

Dear Marco,

We installed version 7.1 beta 2, but autocompletion for different schema doesn't work.

In SQL window we execute the following:

alter session set current_schema = "...";
select * from tbl...
Press F6 - nothing happened

Will you please comment. May be there are some additional options that should be activated?

Regards,
Kirill

 

[Marco Kalter]

Don't worry, this will definitely be added for the final 7.1.0 release. We still have some minor features to add.

 

[Kirill S.]

Ok, thank you. Waiting...

Regards,
Kirill