---------------------------
Debugger Exception Notification
---------------------------
Project Project1.exe raised exception class EOraError with message 'ORA-01008: not all variables bound
'. Process stopped. Use Step or Run to continue.
---------------------------
OK Help
---------------------------
I have been trying many things with no luck.
Not sure whether the problem is this:
It seems that oracle is getting the Query:
UPDATE SOME_TABLE SET NAME = 'XYZ' WHERE SOME_ID=:1
where as it should get query:
UPDATE SOME_TABLE SET NAME = 'XYZ' WHERE SOME_ID=49
?
Code:
Code: Select all
SQLConnection->DriverName = "DevArtOracleDirect";
SQLConnection->LibraryName = "dbexpoda.dll";
SQLConnection->VendorLib = "dbexpoda.dll";
SQLConnection->GetDriverFunc = "getSQLDriverORADirect";
SQLConnection->Params->Clear();
....Database, Password etc....
SQLConnection->Params->Add("LocalCode=0000");
SQLConnection->Params->Add("BlobSize=-1");
SQLConnection->Params->Add("Oracle TransIsolation=ReadCommitted");
SQLConnection->Params->Values["TrimFixedChar"] = "1";
SQLConnection->Params->Values["MetaData"] = "0";
SQLQuery->SQLConnection = SQLConnection;
SQLQuery->SQL->Text = "UPDATE SOME_TABLE SET NAME = 'XYZ' WHERE SOME_ID=:mm";
SQLQuery->ParamByName("mm")->ParamType = ptInput;
SQLQuery->ParamByName("mm")->DataType = ftInteger;
SQLQuery->ParamByName("mm")->Value = 49;
SQLQuery->ExecSQL(true);