Parameters for TOraScript ( ODAC Version 9.6.19 ) does not work anymore
Posted: Fri 11 Sep 2015 08:52
Hi ODAC Support Team,
while testing the new ODAC version ( 9.6.19 for C++ Builder XE 7 )
the following source doesn't work anymore :
The following error occurs : EDatabaseError "Parameter PARAM1 not found"
In the previous version ( 9.5.18) of ODAC i have no problems with it.
Thanks for any help.
while testing the new ODAC version ( 9.6.19 for C++ Builder XE 7 )
the following source doesn't work anymore :
Code: Select all
OraScript1->Params->Clear();
OraScript1->SQL->Text = "SELECT * FROM SOE.CUSTOMERS WHERE CUSTOMER_ID = :PARAM1 ;";
for (int i = 0; i < OraScript1->Statements->Count; i++) {
// here it throws the exception
OraScript1->Statements->Items[i]->Params->ParamByName("PARAM1")->DataType = ftInteger;
OraScript1->Statements->Items[i]->Params->ParamByName("PARAM1")->AsString = 2382;
}
OraScript1->DataSet = SmartQuery1;
OraScript1->Execute();
In the previous version ( 9.5.18) of ODAC i have no problems with it.
Thanks for any help.