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

Last updated on AUGUST 22, 2016

Applies to:

LODESTAR EIP - 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

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