You convert LONG to CLOB and then read it into your character variable using DBMS_LOB.READ. Alternatively, you can use Java and/or EXTPROC.
On 2002.09.01 15:48 sun449 wrote: > Dear List, > > This is what I'm trying to do in a stored procedure. > 1) Read a long raw column from a table into a varchar2 variable. (Let's > assume that each value contains a not-too-long text value.) > 2) Parse it to create a bunch of insert statements and execute them. > > Step 2 is something I understand how to do. But, I've no clue how to do > step 1. I've spent a few hours trying to figure out the tools I need for > this. All my research turns up information on how to convert long raw to > blob/clob etc. and the advantages of blob/clob over long raw and so on. > My impression is that dealing with long raw is considered so basic that > people don't even mention it :-) > > I'd appreciate any pointers. > > Thanks for your time, > - Rao > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: sun449 > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
