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 AUGUST 09, 2021
Applies to:Oracle Forms - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
Windows 10 64-bit
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.
ORA-03116 Invalid buffer length passed to a conversion routine.
Remove the fields that were added to the query - forms work
Add the fields and add the query causes the error/issue. Error occurs when attempting to query the database from the package.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document