Re: TRIGGER truncates data.....
Posted by:
Bob Field
Date: May 08, 2006 02:54PM
Since the column is of type int, anything following the first decimal place is apparently being eaten before the trigger is even invoked, because data conversion is taking place before the trigger call. Calling inet_aton('192') returns 192.
Subject
Views
Written By
Posted
4349
May 08, 2006 01:51PM
Re: TRIGGER truncates data.....
1933
May 08, 2006 02:54PM
1974
May 08, 2006 08:05PM
1816
May 08, 2006 08:33PM
1941
May 08, 2006 08:50PM
1677
May 08, 2006 09:11PM
1837
May 08, 2006 09:14PM
1900
May 08, 2006 09:23PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.