In article <8qmisu$a0j$1_at_nnrp1.deja.com>,
tedchyn_at_yahoo.com wrote:
> Sir, is there a way converting long to long raw data type ?
> thnx in advance.
> ted chyn
>
Since long and raw are both obsolete data types starting with version 8
that exist only for backward compatibility I would suggest you consider
converting the long to a LOB. I believe with 8.1.5+ there is a
function to convert long to LOB's, but in version 8 you have to write
code. If the length of the data in the long is under 32K you can read
the long into a pl/sql varchar2 variable and then use the dbms_lob
package to insert it into a table. If LOB's are out of the question
your best bet is probably going to be pro*c.
--
Mark D. Powell -- The only advice that counts is the advice that
you follow so follow your own advice --
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Sep 25 2000 - 08:30:56 CDT
