Optimistic locking
JoLOct 29 2012 — edited Nov 2 2012Hi all,
I have a page with a Form on a table, I use a package PL/SQL to insert, update and delete a row from table.
I need to implement the Optimistic Locking to prevent Lost Update, in my package I use the MD5 checksum to check the "row version" and all works fine.
But instead of use custom select to fetch data and get the MD5 checksum
(SYS.UTL_RAW.cast_to_raw(SYS.DBMS_OBFUSCATION_TOOLKIT.md5(...))
can I use the builtin APEX Automated Row Fetch process? If yes, how can I get the MD5 value?
Thanks,
Sergio