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 PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Andrey Bronfin
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
