Good morning, my name is Javier, and I have been working with APEX for a year now. I am working on a project that connects to a SQL server via a datalink. So far, I am able to retrieve all records and fields when I am using SQL Workshop\SQL Commands (A) and create a view from it. However, when I create an interactive report and link it to the view, I get error “ORA-00997: illegal use of LONG datatype” when I tried to Synchronize Columns in the Interactive Grid (B). I think the issue is with the "Comments" field.
(A)
(B)
Any help will be much appreciated.
Regards, Javier