Is it possible to extract embedded fields from RAW data?

All:

I have a column in a table defined as RAW(50) which contains a 4-byte integer followed by null terminated character string. In SQL*Plus the column gets displayed as a series of hex digits (and rightfully so!). Is there a way extract/convert these individual fields so that they can be displayed in SQL*Plus as a decimal number and a character string? I know that I can go in for an OCI or Pro*C/C++ or Java solution but I am trying to avoid it if I can. Any PL/SQL possibilities?

Thanks in advance.
-- Dinesh Received on Thu Oct 25 2001 - 10:05:27 CDT