Several bugs and feature requests

[Sergei.Agalakov]

Hi,
All my examples are based on Oracle's standard example schemas HR and OE (Oracle 9i and up).
First, there where some promises of old about some Oracle Spatial support, some of them dated back to year 2004 and 2005
http://www.allroundautomations.com/ubb/ultimatebb.php?ubb=get_topic;f=3;t=001935#000000
http://www.allroundautomations.com/ubb/ultimatebb.php?ubb=get_topic;f=3;t=000970#000000
http://www.allroundautomations.com/ubb/ultimatebb.php?ubb=get_topic;f=3;t=002989#000000
I would like to be able to edit Oracle Spatial type fields in PL/SQL developer, or at very least see it properly. Is it going to happen?

Now about some bugs. In Oracle OE schema PL/SQL Developer improperly shows tables MDRT* (spatial indexes, it is arguable that there are still has be visible as real tables).
Much worse, it also shows nested tables PRODUCT_REF_LIST_NESTEDTAB and SUBCATEGORY_REF_LIST_NESTEDTAB as real tables, even generates meaningless DDL for them like
-- Create table
create table SUBCATEGORY_REF_LIST_NESTEDTAB
tablespace EXAMPLE
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 80K
minextents 1
maxextents unlimited
);
You can see that it doesn't have any columns.
Oracle SQL Developer has the very similar problem, but Oracle Enterprise Manager (JAVA) handles them fine.
In PL/SQL Developer you will also see SYS_IOT_OVER* tables - it plainly doesn't make any sense.
All nested and IOT overflow tables have to be hidden from the tables lists; and secondary tables that support domain indexes al least have to be identified by different color because you shouldn't edit them.

Do you have any plans to support Unicode? Oracle SQL Developer has it, you can see text in any language. It is a low priority to me though.

I would also support request to return back an old CTRL-M functionality that was allowed to jump between opening and ending brackets (not select them - jump between them). It existed in PL/SQL Developer 6.0, it doesn't work in PL/SQL Developer 7.0.2
http://www.allroundautomations.com/ubb/ultimatebb.php?ubb=get_topic;f=3;t=002784#000002

Thank you,

Sergei Agalakov

 

[Marco Kalter]

The spatial and index issues are on the list of enhancement requests. I don't have a date yet though.

Unicode support is in the next patch release. We'll have a beta version available shortly.

The Ctrl-M functionality is on the to-do list as well.