||Oracle Tips by Burleson
Oracle 10g Extra Attributes in LCR and procedures and
functions for LCR types
cscn := lcr.get_commit_scn();
INSERT INTO audit_lcrs values (tab_own,tab_name, action, SYSDATE,
The above procedure takes an event as input
from the sys.anydata queue. Then it extracts the details as needed.
This member function provides the ability to
get and set extra attributes in LCRs. This function returns the
value for the specified extra attribute in an LCR, and the
set_extra_attribute member procedure enables you to set the value
for the specified extra attribute in an LCR.
This member function returns the minimal
database compatibility required to support an LCR.
Get the complete story:
To get the code instantly, click here:
Need an Oracle Mentor?
BEI is now offering personal mentors for Oracle DBAs where you can have an
Oracle expert right at your fingertips, anytime day or night. We work with
hundreds of Oracle databases every year, so we know exactly how to quickly
assist you with any Oracle question.
Why risk an unplanned outage? You can now get telephone access to Don
Burleson or any of his Oracle Certified DBAs with more than 20 years of
full-time IT experience. Click here for details: