Skip to Main Content

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!

Invalid number error when using apex_region.open_query_context

Kinjan BhavsarMay 21 2022

Hi All,
Has anyone used apex_exec API with the classic report?
I am getting invalid number an error every time when I use the following PL/SQL code on line 

v_context := apex_region.open_query_context (p_page_id => :APP_PAGE_ID,
                                             p_region_id => v_region_id);
select region_id
      into v_region_id
      from apex_application_page_regions
     where application_id = :APP_ID
       and page_id = :APP_PAGE_ID
       and static_id = 'my_static_id';

  -- Get the query context for the report
  v_context := apex_region.open_query_context (p_page_id => :APP_PAGE_ID,
                                               p_region_id => v_region_id);

v_id := apex_exec.get_column_position(v_context, 'MY_COLUMN_NAME');

I am using this piece of code in a page process to fetch all data and update values in DB. I am using APEX 20.2 and 18c DB.
Let me know if anything is wrong with this logic?
Thanks

This post has been answered by Carsten Czarski-Oracle on May 23 2022
Jump to Answer

Comments

Khalil Dahham

I have the same error simply by deploying ORDS on Tomcat locally. I'm using ORDS (21.1.3.153.1102) and Tomcat (10.0.11) installed on windows 10.

User_16TSJ
Answer

I never found the solution for the issue, but I believe it was related to Tomcat 10.x. I downgraded Tomcat to version 9 and the error went away.

Marked as Answer by User_16TSJ · Sep 19 2021
Khalil Dahham

Yes it worked on 9! This will do for now. Thanks.

cormaco

Tomcat 10 is not yet supported by Oracle:
Supported Java EE Application Servers
Application ServerSupported Release
Oracle WebLogic Server 12c Release 2 (from version 12.2.1.3 and later) and 14c Release and later
Apache Tomcat Release 8.5.x through Release 9.0.x

Mohan Poojari

I never found the solution for the issue, but I believe it was related to Tomcat 10.x. I downgraded Tomcat to version 9 and the error went away.

Yes, ORDS will absolutely NOT work on Tomcat 10 today.

1 - 6

Post Details

Added on May 21 2022
11 comments
623 views