Hi,
I am trying to create an Interactive Report on the user_constraints table.
If I use the local table it works correctly but if I use:
SELECT
CONSTRAINT_NAME,
CONSTRAINT_TYPE,
SEARCH_CONDITION
FROM
user_constraints@SCHEMA
WHERE
TABLE_NAME = :P3_TABLE;
via a database link it returns ORA-00997: illegal use of the LONG datatype.
However if you run the query in the Apex SQL Workshop it works correctly.
Any thoughts on if this can be resolved would be greatly appreciated.
Kind Regards
Dave