Sql.parm Miscount Error in Equations with Callable SQL that Uses Custom Function (Doc ID 1458326.1)

Last updated on MARCH 06, 2017

Applies to:

PeopleSoft Enterprise CS Financial Aid - Version 9 and later
Information in this document applies to any platform.

Symptoms

The following occurs when executing an equation engine that uses a callable SQL (with a custom function):
 
Sql.parm miscount in equation
The parameters in a call to an SQL statement were not equal to the number of bind variables plus the number of selected values plus 2. All parms are local with whatever names you want in this order: returncode, sqlrowcount, bindvalue1, bindvalue2, ....selectfield1, selectfield2....

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