Param name in TOraStoredProc

[JFlo]

After migration to ODAC 8.6 from 7.20 I encounter a strange behavior: 1. call to a stored proc with parameters using the following code sniplet
oraProc->StoredProcName = "TEST.TESTPROC";
oraProc->Params->Clear();
oraProc->Params->CreateParam(ftString,"name",ptInput);
oraProc->Params->ParamValues["name"] = "ABC";
oraProc->ExecProc();
oraProc->Close();
executes correctly (in dbMonitor I see the parameter "name"="ABC").
A 2. call to the same code returns an error and in dbMonitor I see the parameter "NAME"=<null> since it is now UPPERCASE.

[AlexP]

Hello,

Please try to reproduce the problem on the latest ODAC version 9.0.1. If the problem can be reproduced on it, provide the script for creating your procedure.

[JFlo]

Hello

I found a strange workaround to solve the problem:

After changing:
oraProc->ExecProc();
oraProc->Close();
to:
oraProc->Prepare();
oraProc->ExecProc();

the code worked in 7.20 and in 8.6 successfully again.
I will try it with 9.0.1 as soon as I have it installed.