v8. Table's context menu changed?

[Duddha]

In previous versions of PL/SQL Developer it was very convenient to get (edit) table's data from SQL Window by right clicking on it's name and choosing "Query data" and so on. In new version (8.0.0.1480) I can't get this menu - it presents in Object browser but not in SQL Window (see images):
Object browser

SQL Window

(there are no Query/Edit data, View, Edit, Rename and other commands)

Is this a feature or bug?

 

[DoDo]

I can not reproduce this error, for me everything works properly.
Are you sure that you have correctly written the name of the table?

 

[patch]

Maybe you can try to completely select the table name before you right click the object.
Kindest regards,
Patrick Barel

 

[Duddha]

Maybe you can try to completely select the table name before you right click the object.

It doesn't help

Tried to install it on a virtual machine (VirtualBox) and it's the same.

I've just experimented: uninstall v8 from virtual machine, install v7 - all menus are Ok, install v8 above v7 - no commands in menu.
I just can't get where it's may be - PL/SQL Developer's preferences, my DB rights or something else

 

[Duddha]

Are you sure that you have correctly written the name of the table?

Yes, i'm sure - i'm using Code Assistant for it. Anyway even on DUAL it doesn't work

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the shortcut and add the debugsql parameter? For example:

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

Righ-click on DUAL in the SQL Window and send me the debug.txt file that is generated in the PL/SQL Developer directory.

 

[Duddha]

To obtain some more diagnostic information, can you modify the shortcut and add the debugsql parameter? For example:

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

Righ-click on DUAL in the SQL Window and send me the debug.txt file that is generated in the PL/SQL Developer directory.

I've just sent it to you in PM

 

[Marco Kalter]

Thanks. Can you also let me know your Oracle Server version?

 

[Duddha]

Oracle9i Enterprise Edition Release 9.0.1.4.0

 

[patch]

I meant just select the table name, not the

..

 

[Duddha]

I meant just select the table name, not the

..

That was .

 

[Duddha]

Researching debug.txt I've found calling of sys.dbms_utility.name_resolve procedure to resolve object's under mouse type by it's name.
I've attempted to execute it with such parameters:
sys.dbms_utility.name_resolve(name => 'DUAL',
context => 0,
schema => vSchema,
part1 => vPart1,
part2 => vPart2,
dblink => vDBLink,
part1_type => vPart1_type,
object_number => vObject_number);
and got a error:
ORA-20005: ORU-10034: context argument must be 1 or 2 or 3 or 4 or 5 or 6 or 7

but no one value from 1 to 7 didn't match - ORA-06564: object DUAL doesn't exists.
E.g. for package, function and procedure the "1" was Ok.

Maybe this is a problem?

 

[Marco Kalter]

It should have returned a table for context = 2. Can you verify this?

Begin
  Sys.Dbms_Utility.Name_Resolve(Name          => 'DUAL',
                                Context       => 2,
                                Schema        => :Object_Owner,
                                Part1         => :Part1,
                                Part2         => :Part2,
                                Dblink        => :Dblink,
                                Part1_Type    => :Part1_Type,
                                Object_Number => :Object_Number);
End;

 

[Duddha]

2 Marco Kalter
It doesn't work:
ORA-06564: object DUAL doesn't exists
ORA-06512: at "SYS.DBMS_UTILITY", line 94

 

[Duddha]

from Metalink (DocID 1008700.6, modified 25-OCT-2005) :

Problem Description:
====================

When you use dbms_utility.name_resolve on a table, you get
the Oracle error ORA-06564 OBJECT name DOES NOT EXIST.

Problem Explanation:
====================

Solution Description:
=====================

The dbms_utility.name_resolve procedure is supported only for procedures, functions, and packages, not tables. Note the valid return types for part1_type, which is one of the parameters of the procedure, are
5 = synonym
7 = procedure
8 = function (top level)
9 = package (top level)

For more information about the dbms_utility.name_resolve procedure,
see the Oracle7 Server Documentation Addendum Release 7.1 page B-2.

Enhancement request 263534 has been filed requesting that tables be
added as valid objects for the dbms_utility.name_resolve procedure.

Maybe it was changed later, but not in my version of Oracle

 

[Duddha]

For another test I've connected to Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - everything is Ok there.

So the problem is in version of my Oracle, isn't it?

 

[Marco Kalter]

Yes. It turns out that the name_resolve function should only be used on 9.2 and later. It looks like PL/SQL Developer is using it in 9.0 and later by mistake. I will upload a fix shortly and will post a link here.

 

[Duddha]

Thanks Marco.
Will wait for fix

 

[Marco Kalter]

Can you try this version?

 

[Duddha]

Marco everything is Ok in this version.
Thank you very much!

 

[Marco Kalter]

Okay, thanks for letting me know.