Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-06512: at "APEX_240100.WWV_FLOW_COMPUTATION", line 317

Kalyani PasupulatyMar 14 2025 — edited Mar 15 2025

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.

Comments

Post Details

Added on Mar 14 2025
#apex-discussions, #oracle-apex
2 comments
73 views