I am trying to get the utl_raw.cast_from_number function to pass data to
a 3rd party application. I am kind of confused as to how it gets
converted into a binary format. Are these hexadecimal values? Why do
the results vary so much in their length?


100 C202
200 C203
300 C204
400 C205
500 C206
1000 C20B
10000 C302
100000 C30B
1.2 C10215

On Thu, 27 Oct 2011 13:28:54 -0400, NewtoOrcl <newtoorcl (AT) yahoo (DOT) com>
wrote:

What are these values? Is one the result of applying a function
to the other?

They might be hexadecimal be though 1.2 is unusual. It is also
possible that the values for either column are not numeric.

Why do decimal numbers vary so much in their length? Sometimes,
more digits are required.

Sincerely,

Gene Wirchenko

NewtoOrcl (newtoorcl (AT) yahoo (DOT) com) writes:
I had never heard of this utl_raw.cast_from_number function before, so
I searched for it on Google. It appears that this is a function in Oracle,
so you are in the wrong newsgroup. I suggest that you try
comp.databases.oracle instead.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

On 10/27/2011 2:05 PM, Gene Wirchenko wrote:

This was meant for the Oracle group - a mistake on my part that I have
since corrected. Sorry for the confusion.