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

Last updated on AUGUST 04, 2017

Applies to:

Oracle Imaging and Process Management - Version 10.1.3.3.1 and later
Information in this document applies to any platform.

Symptoms

When using the "Filing Maintenance" interface in 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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms