Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Optimistic locking

JoLOct 29 2012 — edited Nov 2 2012
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 30 2012
Added on Oct 29 2012
11 comments
617 views