I have developed an APEX page to perform conversational inquiry in apex page using generative AI where I am using OPEN AI service provider.
I am following the same steps provided in the oracle documentation Run Workshop - Build an Innovative Q&A Interface Powered by Generative AI with Oracle APEX
Section : Build a Conversational Inquiry about Schools using Generative AI.
Steps to reproduce: In the Property Editor, enter/select the following:
Execution > Point: Before Regions
Under Computation:
Type: SQL Query (return single value)
SQL Query: For the SQL Query, we will make use of the APEX Assistant to generate the query. Follow the next steps to generate the SQL query. Click the Code Editor icon..
This SQL query has a limitation, if I write query which returns more than 500 records I am getting the error
"is_internal_error: true
apex_error_code: APEX.COMPUTATION.UNHANDLED_ERROR
ora_sqlcode: -6502
ora_sqlerrm: ORA-06502: PL/SQL: value or conversion error: character string buffer too small".