SQL & PL/SQL

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!

get_hash_value

707125Jun 16 2009 — edited Jul 23 2009

I'm trying to use this on a long datatype but it complains .........ORA-00997: illegal use of LONG datatype. Im simply trying to generate a view of a table with an additional column that contains this hash value to enable the tool im using to establish any changes in the records.

I also thought of using owa_opt_lock.checksum but I couldn't use this in the inline query, i.e. ORA-14551: cannot perform a DML operation inside a query.

Any help will be most appreciated. Thank you in advance.

This post has been answered by MichaelS on Jun 17 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 20 2009

Added on Jun 16 2009

11 comments

4,375 views