Hello

I only created a simple grid. Now I get the following error: Logging exception: Sqlerrm: ORA-00911: Ungültiges Zeichen Backtrace: ORA-06512: in "SYS.DBMS_SYS_SQL", Zeile 1325 ORA-06512: in "SYS.WWV_DBMS_SQL", Zeile 464 ORA-06512: in "SYS.WWV_DBMS_SQL", Zeile 475 ORA-06512: in "APEX_050000.WWV_FLOW_DYNAMIC_EXEC", Zeile 413

I found the message in the debug. Is it possible to find out which coloumn raises this error? In the SQL query, there are only selected VARCHAR2 columns. The table also holds CLOB Data, which is not selected in the query.

Kind Regards, Christian

This exception is being raised in the APEX engine. This sounds like a syntax issue in the Query. Can you please send the APEX debug output which this exception appears in to support@tryfoexnow.com.

It might be worthwhile creating a test case on trial.tryfoexnow.com with the query and just create the underlying table(s) not data in your trial workspace to ensure it is not an issue with the actual query itself.

Hi Matt.

This is really strange, I tried the same query a few times and now it works, but I didn´t change anything.

Kind Regards, Christian