I have developed an APEX page to perform conversational inquity 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 "https://apexapps.oracle.com/pls/apex/r/dbpm/livelabs/run-workshop?p210_wid=3947&p210_wec=&session=16201049682701"
Section : Build a Conversational Inquiry about Schools using Generative AI.
I am getting 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 smallORA-06512: at "APEX_240100.WWV_FLOW_COMPUTATION", line 317 ORA-06512: at "APEX_240100.WWV_FLOW_COMPUTATION", line 238 ORA-06512: at "APEX_240100.WWV_FLOW_STRING", line 645 ORA-06512: at "APEX_240100.WWV_FLOW_FORMS", line 246 ORA-06512: at "APEX_240100.WWV_FLOW_COMPUTATION", line 137 ORA-06512: at "APEX_240100.WWV_FLOW_COMPUTATION", line 306.
This issue is occuring when I am using computation field to send the data from oe_order_details table to open ai.