Main Region

Invalid Character in grid
2 answers | 413 views

CH
Aug 26, 2015 05:39 +00:00

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

2 comments

MN
Matt Nolan Aug 26, 2015 07:26 +00:00 

Sounds like a meta (hidden character) in your original query when the problem arose.

CH
Christian86 Aug 26, 2015 08:31 +00:00 

This could be a possibility. Thanks....

MN
Aug 26, 2015 06:21 +00:00

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.

0 comments

CH
Aug 26, 2015 07:21 +00:00

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

0 comments

You must log in or sign up to post questions and answers.