We have a table in which a field is stored as binary. The field contains
mostly text data and some color info in binary. A guy writing report needs to
read this field as text and he does not care about the color infor in binary.
We are trying to write a stored procedure to convert the binary info in this
field to ASCII data. We will create a separate view of thei table for him.
Could anyone let us know if this is the right way? If not, what is it? If
yes, what Oracle function should we use? Thanks,
Muyi Cui
Dentrix Dental Systsems
mcui_at_dentrix.com
Received on Mon Jan 04 1999 - 11:46:52 CST
