My Oracle Support Banner

Variables Passed in Incorrect Order when Calling a Stored Procuedre from Rules Language (Doc ID 1603765.1)

Last updated on OCTOBER 06, 2022

Applies to:

Oracle Utilities Energy Information Platform - Version 1.6.1.13 and later
Information in this document applies to any platform.

Symptoms

When accessing a stored procedure through Rules Language and the stem variables are more than 9 fields, the variables are not passed in the correct order.
For instance :

stem.p1 = param 1
stem.p2 = param 2
stem.p3 = param 3
stem.p4 = param 4
stem.p5 = param 5
stem.p6 = param 6
stem.p7 = param 7
stem.p8 = param 8
stem.p9 = param 9
stem.p10 = param 10

Calling the stored procedure (stem, ....),

Results that :

(param1, param10, param2, param3, param4, param5, param6, param7, param8, param9, .........)
The parameters p2 and p10 will be inverted.

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