My Oracle Support Banner

Getting ''SQLState 22002: Indicator variable required but not supplied'' Error Within IPM Filer (Doc ID 734245.1)

Last updated on OCTOBER 02, 2023

Applies to:

Oracle Imaging and Process Management - Version 10.1.3.3.1 to 10.1.3.6 [Release 10gR3]
Information in this document applies to any platform.

Symptoms

When using the "Filing Maintenance" interface in IPM Filer, and trying to delete batches associated with an application, or deleting an application, the interface can throw a pop-up message indicating that the deletion failed due to an ODBC error:

''SQLState 22002: Indicator variable required but not supplied"

Selecting OK reports that the last filing was deleted but that there is still data in the application.  All of the other filings are still actually there.

Closing and reopening the Filer GUI shows that the other batches are still listed, but the one that was supposed to be deleted is no longer in the list.

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

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