"ORA-01436": CONNECT BY error when using the "Used By" tab in Schema Browser (4266261)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

"ORA-01436": CONNECT BY error when using the "Used By" tab in Schema Browser
Description

I am generating an ORA-01436: CONNECT BY loop in user data when using the Used By tab in schema browser on some of his objects. (tables, procs, functions)
Some data is returned, however, the error does happen in Oracle.

In addition, SQL PLUS returns some rows while in Toad it displays zero, so there is a difference in behavior.
Resolution

WORKAROUND:
None

STATUS:
Waiting for fix to be released in a future version of Toad for Oracle.
Defect ID

CR118286

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title