Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00997: illegal use of LONG datatype - Apex 19.2

ManuelGonzalezFeb 28 2020 — edited Mar 1 2020

i everyone,

I have a dblink from oracle to Postgres 11.5 which is in Centos 7.

Use Oracle XE 18c with Apex 19.2 also in CentOs 7.

I have created a view in postgres which I consult without problems from the Oracle database:

pastedImage_0.png

In the same way it is consulted satisfactorily from Apex SQL Command:

pastedImage_0.png

But when I want to load that data from an Interactive Report it generates the following error:

pastedImage_2.png

Any idea what might be happening?
Comments
Post Details
Added on Feb 28 2020
#apex-discussions, #bug
2 comments
564 views