From: "Kennedy, Jim" <jim_kennedy@xxxxxxxxxx>
Reply-To: jim_kennedy@xxxxxxxxxx
To: <davidb158@xxxxxxxxxxx>, <Oracle-L@xxxxxxxxxxxxx>
Subject: RE: Oracle implicit data conversion
Date: Tue, 1 Nov 2005 13:35:36 -0800
I usually create a package that all the triggers call to add rows to the
audit table. In the interface to the package I have one set of calls
that takes a date as a parameter. In that interface I explicitly
convert the date to a character. Eg
Audit_pkg.Audi_info(v_table_name in varchar2, v_field_name in varchar2,
v_operation in varchar2, old_value in varchar2,new_value in varchar2);
Audit_pkg.Audi_info(v_table_name in varchar2, v_field_name in varchar2,
v_operation in varchar2, old_value in date,new_value in date);
Audit_pkg.Audi_info(v_table_name in varchar2, v_field_name in varchar2,
v_operation in varchar2, old_value in number,new_value in number);
Audit_pkg.Audi_info(v_table_name in varchar2, v_field_name in varchar2,
v_operation in varchar2, old_value in timestamp,new_value in timestamp);
I have the Audit_pkg.Audi_info with date, number, and timestamp argument
types do the conversion and then turn around and call
Audit_pkg.Audi_info with varchar2 argument types.
Jim
