When Querying Database for Exporting Forms to Excel Receive ORA-03116: Invalid Buffer Length Passed to a Conversion Routine (Doc ID 2798176.1)

Last updated on APRIL 25, 2023

Applies to:

Symptoms

Environment
--------------
Forms 12.2.1.3.0
Database 19.3.0.0.0
Windows 10 64-bit

Problem
------------
Calling a database package that queries the database and returns a ref cursor (via an OUT parameter) to forms, which then outputs the data to an Excel document.

Previously worked. It stops working in forms when modify the query within the package to select additional fields. It only stops working in forms. If copy the code from forms and run it from a tool such as Toad or Golden, the code runs fine. If remove the fields that were added to the query, forms starts working again.

The form allows the user to show the data as a report, or export the data to Excel. When exporting, the user cannot specify the sort and break order. This feature was only implemented for the report. The report is working fine.

Error occurs when attempting to query the database from the package.

Error
----------
ORA-03116 Invalid buffer length passed to a conversion routine.

Works
-------------------
Remove the fields that were added to the query - forms work

Not Work
-----------------
Add the fields and add the query causes the error/issue. Error occurs when attempting to query the database from the package.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.