Dear list !

There is a column of datatype RAW in a table.
it contains 4 numbers (4 bytes each) and a string of 54 bytes , that are
concatenated and then converted to RAW by an external C++ application.
I need to convert it back in a PL/SQL trigger.
I.e. i need retrieve that RAW column , and divide it according to the offset
to the 4 numbers and the string.
The problem is that i haven't found any cast_to_number or hextonumber
conversion functions .
UTL_RAW only has got CAST_TO_VARCHAR2 function , and there is also the
standard RAWTOHEX conversion function.
How can i sort it out , please ?

Thanks a lot in advance ,

DBAndrey

* 03-9254520
* 053-464562
* mailto:[Email Address Removed]Oracle LazyDBA home page