RE: Oracle implicit data conversion

From: David Boyd <davidb158_at_hotmail.com>
Date: Tue, 01 Nov 2005 16:51:41 -0500
Message-ID: <BAY20-F9FE9437B1265C7CB94648EF6F0@phx.gbl>

Jim,

That's a good way to do explicit data conversion. Thanks for sharing your package with me. This is my next step.

Dave

>From: "Kennedy, Jim" <jim_kennedy_at_mentor.com>
>Reply-To: jim_kennedy_at_mentor.com
>To: <davidb158_at_hotmail.com>, <Oracle-L_at_freelists.org>
>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

---

FREE pop-up blocking with the new MSN Toolbar – get it now! http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Nov 01 2005 - 15:53:45 CST