Re: Converting from Long to Lob..

From: SL <sebastien-louchart_at_wanadoo.fr>
Date: 15 Dec 2005 03:23:12 -0800
Message-ID: <1134645792.827386.203300@g44g2000cwa.googlegroups.com>

Hello,

Take a look at the TO_LOB function in the Oracle SQL reference. The changes needed in the client application are usually the use of LOB-related functions/methods instead of RAW-related functions methods. IIRC, in Java, you use Statement.setBytes for LONG and LONG RAW. With LOBs you'd rather use setBlob or something similar.

BTW, may we have any clue about the Oracle server version you're using or by chance, any clue about the client app's programming technology (Java, OCI, etc), it'd be useful.

HTH

-- 
SL

Received on Thu Dec 15 2005 - 05:23:12 CST