Hi,
I have a systematic hang of pl/sql dev.
It happens in a sql window in query by example or edit mode. The editor should show an arrow on the right side. Instead the cursor becomes an hourglass and pl/sql dev freezes.
The cpu usage is 100%.

Is it possible to disable the auto-search of foreign key ?

Jean-Paul

plsql/dev : 6.0.3.893
db:10.1.0
windows xp sp2 P4 2.6 1.5 giga de ram.

I cannot reproduce this. Does the problem occur for a specific foreign key or for all foreign keys?

Note that you can disable this feature through Tools > Preferences > SQL Window > "Show dictionary info in result grid".

I have the problem for all the foreign keys to the same table. All other foreign keys work ok.
I removed the foreign key and recreate it. I still have the same problem.

The work around works.

"Show dictionary info in result grid" should be 2 options:
one to display the info on the status bar and one to display the combo box.


The script to recreate tables with the problem.
Plsql/dev hangs when I edit the value of id_tbl
-- Create table
create table ZS_TABLE
(
ID NUMBER(10) not null,
NAME VARCHAR2(40) not null,
ID_KEY NUMBER(10),
ID_TS NUMBER(10),
MEMO CLOB,
ID_ZS_COLUMN_P NUMBER(10),
MC_SEQUENCE NUMBER(5) default 9100,
LML_DESC_S VARCHAR2(255),
LML_DESC_L VARCHAR2(255),
TS NUMBER(10) not null,
CREATE_BY NUMBER(10) not null,
CREATE_AT DATE not null,
YN_HU NUMBER(2) default 0,
IDK_ZS_APP NUMBER(3) not null,
MC_TABLE_DEF NUMBER(4) default 9360 not null,
YN_DELETED NUMBER(1) default 0,
XML_SYNCHRO SYS.XMLTYPE,
MODIFIED_AT DATE,
MODIFIED_BY NUMBER(10),
YN_INTERNAL NUMBER(1) default 0 not null,
YN_UPDNOTIF NUMBER(1) default 0 not null
)
tablespace GLOBO
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
-- Create/Recreate primary, unique and foreign key constraints
alter table ZS_TABLE
add constraint PK_ZS_TABLE primary key (ID)
using index
tablespace GLOBO
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
-- Create/Recreate check constraints
alter table ZS_TABLE
add constraint CKC_38_MC_SEQUENCE
check (MC_SEQUENCE in (9101,9102,9100));
alter table ZS_TABLE
add constraint CKC_38_MC_TABLE_DEF
check (MC_TABLE_DEF in (9364,9360,9361,9363,9362));
alter table ZS_TABLE
add constraint CKC_38_YN_DELETED
check (YN_DELETED between 0 and 1);
alter table ZS_TABLE
add constraint CKC_38_YN_HU
check (YN_HU between 0 and 1);


-- Create table
create table JPF_COLUMN
(
ID NUMBER(10) not null,
DBNAME VARCHAR2(40) not null,
ID_TBL NUMBER(10) not null,
ID_ZS_DOMAIN NUMBER(10) not null,
MINIMUM VARCHAR2(40),
MAXIMUM VARCHAR2(40),
DEFAULT_VALUE VARCHAR2(40),
CANNOT_MODIFY NUMBER(2) default 0 not null,
ID_Z_MC_M NUMBER(10),
MANDATORY NUMBER(2) default 0 not null,
YNE_HU NUMBER(4) default 12 not null,
TS NUMBER(10) not null,
CREATE_BY NUMBER(10) not null,
CREATE_AT DATE not null,
MEMO CLOB,
SEQ_NUM NUMBER(5),
YN_MASSIVE_UPD NUMBER(1) default 0 not null,
YN_DELETED NUMBER(1) default 0 not null,
MINCHAR NUMBER(2) default 0 not null,
YN_DEFERRABLE NUMBER(1) default 0 not null,
MODIFIED_AT DATE,
MODIFIED_BY NUMBER(10)
)
tablespace GLOBO
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
-- Add comments to the table
comment on table JPF_COLUMN
is 'dd';
-- Create/Recreate primary, unique and foreign key constraints
alter table JPF_COLUMN
add constraint XXPK_ZS_COLUMN primary key (ID)
using index
tablespace GLOBO
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table JPF_COLUMN
add constraint xxID_TBL foreign key (ID_TBL)
references ZS_TABLE (ID);

Thanks, we'll check it out.