CTRL + click with DBA views

[Qkxy]

Hi,

according to DebugSQL log in SQL window the CTRL + click function uses the dbms_utility.name_resolve to resolve the object name and type but this procedure runs with the caller privileges and does not resolve names if the caller has no right for the object.
Can you extend the object name and type resolving to select dba views directly if dbms_utility.name_resolve does not resolv the name and the "Use DBA Views if available" option selected?

Best regards, Zolt

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[Qkxy]

Thank you, but this was a working feature in version 7 so would you so kind and handle it as a BUG?
(I have seen "I have added this to the list of enhancement requests" so many times on this forum and I can't believe in the enhancement list.)

My current version is 9.0.4.1645

Best regards, Zoltan.

 

[T-Gergely]

I agree with you: this is a severe regression. This problem also occurs with browse/desc/ed commands in a command window.
(I've also been waiting for xmltype related bugs to be fixed for months now. I don't think it will take long before we look for an open source alternative. TOra, probably.)

 

[Marco Kalter]

You can revert to version 7 behavior by applying the OldNameResolve command-line parameter. For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" OldNameResolve

You can also add the following line to the params.ini file in the PL/SQL Developer directory:

OldNameResolve=1

 

[T-Gergely]

That's great! Thanks.
Don't you have a hidden DontCrashOn100XmltypeRows parameter, too?

 

[T-Gergely]

OldNameResolve does not work for the "Export Tables" function.
On a side note, a text field for entering table names to be exported would be great.