in reply to Extracting long raw data from Oracle

Does the long raw contain what was originally character data? Is it less than 32Kb long?

If so then the easiest solution may be to write an Oracle stored procedure which uses a rawtochar function to convert the long raw to Oracle's varchar2 data type and then returns the varchar2. Have Perl call this stored procedure in order to retrieve the converted long raw values.

Here is an implementation of a rawtochar function which works for long raws of less than 32Kb. I recall that Oracle's documentation also includes a stored procedure which can retrieve and convert long raws of any size.

  • Comment on Re: Extracting long raw data from Oracle