OK, not sure you’re going to be able to duplicate this, BUT when I run a query on a very simple table
CREATE TABLE bsd_rpt_parm
(bsd_rpt_intr_no NUMBER NOT NULL,
bsd_rpt_parm_nam VARCHAR2(30 BYTE) NOT NULL,
bsd_rpt_parm_txt VARCHAR2(2000 BYTE) NOT NULL)
– Constraints for BSD_RPT_PARM
ALTER TABLE bsd_rpt_parm
ADD CONSTRAINT bsd_rpt_parm_pk PRIMARY KEY (bsd_rpt_intr_no, bsd_rpt_parm_nam)
Nav appears to go into a hard loop (I have to kill Nav) any time I list the column 3 in the query. I’ve tried it with other tables with a large column, but it doesn’t seem to cause the same problem.
doing an f3 from the navigator will also cause the lock up.
I can do a select off of the column if I use substring. It seems to die if I get too big however. Doesn’t seem like I can get much over 100.