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 AUGUST 09, 2021

Applies to:

Oracle Forms - Version 12.2.1.3.0 and later
Information in this document applies to any platform.

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.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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