17 Dec
2007
17 Dec
'07
1:14 p.m.
Hi Frank, Ranner, Frank MR wrote: <SNIP>
Oracle doesn't seem to do bit shift. You can multiply by 2^32 instead.
AcctInputOctets = '%{%{Acct-Input-Gigawords}:-0}' * 4294967296 + '%{%{Acct-Input-Octets}:-0}'
Oracle supports up to 38 digit numbers. </SNIP>
Thanks so much for that suggestion, I will give it a go! Best regards, Mike