Hello
When usimg self-referencing types Toad hangs.
Steps to reproduce the issue:
1) Run the following script in toad:
CREATE TYPE subject_t AS OBJECT
(
name VARCHAR2 (200),
broader_term_ref ref subject_t
);
/
CREATE TABLE subjects OF subject_t (
CONSTRAINT subject_pk PRIMARY KEY (name) ,
CONSTRAINT subject_self_ref FOREIGN KEY (broader_term_ref) REFERENCES subjects);
/
2) Then run the following query:
select * from subjects;
Toad hangs
The same select works in sql plus.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center