My Oracle Support Banner

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

Last updated on MARCH 09, 2020

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....

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.