Toad World® Forums

Error when "describing" item through DB_Link


#1

When I have a Synonym that uses a DB_link to a remote table, and I click on that
synonym in Schema Browser, then I get an
ORA-00997: illegal use of LONG datatype error window.

Bringing up a SQL Monitor/Tracker, the error is on the following as it tries to
populate the RHS:

Timestamp: 5/21/2010 1:20:06 PM

Select t.trigger_name, t.trigger_type, t.triggering_event,
t.when_clause, t.status enabled, o.status, t.owner, o.object_id, t.trigger_body
from sys.ALL_OBJECTS@DB2.FLYINGJ.COM o, sys.ALL_TRIGGERS@DB2.FLYINGJ.COM t
WHERE t.table_owner = ‘POST’
and o.object_type = ‘TRIGGER’
and o.object_name = t.trigger_name
and t.table_name = ‘FUEL_TRAIN’
and o.owner = t.owner

Error occurred: [997] (ORA-00997: illegal use of LONG datatype )

Would you consider this a bug, or a feature, or just put up with it?

Toad 10.5.1.3
Oracle 10.2.0.2.0 (on both local and remote databases)

David A. Hicken
UtahToad at gmail dot com
---------- Kiva.org - Make a Small Loan. Make a Big difference.
I wear my wife’s eyeglasses because she wants me to see things her way.
–Jayson Feinburg


#2

Bug. I’ll make a change so that code isn’t executed through a db
link.

If you go to Options -> Schema Browser -> Data tab, and uncheck
“highlight columns populated by sequence/trigger pair”, I think the
problem will go away.