Re: UTL_RAW binary encoding - 2

From: neilsolent <n_at_solenttechnology.co.uk>
Date: Fri, 19 Jul 2013 12:13:10 -0700 (PDT)
Message-ID: <0f2e19f7-e3fe-47c1-a087-1209eff0d471_at_googlegroups.com>

Better solution - fixed 8 byte width raw, and the inverse function:

create function uint2raw(uint in number) return raw as begin

        return hextoraw(to_char(uint, 'FM000000000000000X')); end;
/

create function raw2uint(rawnum in raw) return int as begin

	return to_number(rawtohex(rawnum), 'XXXXXXXXXXXXXXXX');

end;
/

Might be useful to someone.. Received on Fri Jul 19 2013 - 21:13:10 CEST