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:  (ORA-00997: illegal use of LONG datatype )
Would you consider this a bug, or a feature, or just put up with it?
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.