Re: How to transfer varchar2 to long raw

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 31 Aug 2006 06:48:13 -0700
Message-ID: <1157032093.615748@bubbleator.drizzle.com>

tamsun wrote:
> On Wed, 30 Aug 2006 22:57:20 -0700, DA Morgan <damorgan_at_psoug.org>
> wrote:
>

>> tamsun wrote:
>>
>>> field F1 is varchar2(4000), I want move the data in F1 into
>>> another filed F1 which is long raw.
>>> I wonder how to do by sql?
>> Why LONG RAW?
>> What is the business case?
>> In which version of Oracle?

>
> The real field name is YFBZYJ in table T1 and T2.
> I use Oracle 9i.
>
> Some one design the database, the field YFBZYJ is
> used for client to fill opinion which maybe
> 100 characters, or maybe 5,000 characters long.
> So the designer change the origin field type
> from varchar2(4000) to Long Raw.
>
> Yes, Blob or Clob will be better.But web developers use
> a interface to operate database. This interface can only
> deal with long raw.
>
> I am responsible to dealing with data. Now I should
> move data to new table with the long raw field.

Either the web developers are crazy or you have misunderstood what they are saying. LONG RAW is binary ... not text. There is no way an end user is going to use it to store comments.

Check out the Data Types page in Morgan's Library at www.psoug.org to view the various data types and what their definitions.

In my experience there is no interface that does not allow CLOB and you should not accept anything except CLOB without a far better understanding of why anyone is claiming it can not be done. That said ... what product are they using (include version number).

It just occured to me that some Oracle products, Forms for example, still use LONG to indicate LONG or CLOB. Hopefully this misuse of the name will be fixed in Forms 11g.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Thu Aug 31 2006 - 08:48:13 CDT