My Oracle Support Banner

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:

Oracle Forms - Version and later
Oracle Forms for OCI - Version 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

Not 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

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