Namcit99 0 Posted March 27 (edited) Firedac in embarcadero rad studio 12.3 in trial version get issues specific delphi 12.3.Tfdstoreproc and tfdquery don't work well with connection oracle. Run without error but tfdquery show old data after execution tfdstoreproc Edited March 27 by Namcit99 Share this post Link to post
bnreimer42 0 Posted March 27 Sounds like bad or missin transaction handling. Do both use the same transaction? If not do you commit after StoreProc and restart transaction of query? Share this post Link to post
Namcit99 0 Posted March 27 (edited) On 3/27/2025 at 7:52 AM, bnreimer42 said: Sounds like bad or missin transaction handling. Do both use the same transaction? If not do you commit after StoreProc and restart transaction of query? Those codes in click button, from up to down in the same place, i reopen tfdquery, but data not changed, tfdstoreproc.execproc run without error. In storeprocedure i use commit command in oracle Edited March 27 by Namcit99 Share this post Link to post