No, no prior errors are shown in our log. And the SQL we were attempting to execute was just a SELECT with one bind variable. Nothing exotic at all. The code is pasted below -- have a look. There's no way to tell from our error log whether it was executing the .Open or the .Refresh when it died. tblResponse is your TOracledataset. If you have any insights we'd be most grateful....
---------------------------------
if Datamodule1.tblResponse.active = FALSE then
begin
DataModule1.tblResponse.DeleteVariables;
DataModule1.tblResponse.SQL.Clear;
DataModule1.tblResponse.SQL.Add(ResponseSQLByEntryID);
DataModule1.tblResponse.DeclareVariable('EntryID', otString);
DataModule1.tblResponse.SetVariable('EntryID', CurResponseID);
Datamodule1.tblResponse.open;
end
else
DataModule1.tblRESPONSE.refresh;