Newsgroups: comp.databases.oracle
From: dly@vms.macc.wisc.edu
Subject: LONG want to convert to VARCHAR
Message-ID: <1993Jul7.144052.1152@macc.wisc.edu>
Sender: news@macc.wisc.edu (USENET News System)
Organization:  University of Wisconsin Academic Computing Center
Date:  7 JUL 93 09:32:56    
Lines: 22


We are using ORACLE 7.0.12 on Sun/Unix 4.1.3

I made the mistake of creating a table with type LONG.  How can I get
the information out into a file?  I've tried sqlplus with the set long 500
command, with wrap on.  For one specific record, it will print out the
value, but when I want to do the entire table, I get only the first 80
chars or so.

Ultimately, I want to recreate the table with no LONG types at all.
But first I have to get the information out of the LONG type.  Any
body done this?

I also have tried PRO*C, but I keep getting the oracle error, that is
has encountered a null value.  NVL(etc) will not work on LONG types.

Ideas?

Thanks,
Debbie

PS  The usual disclaimer - I've called Oracle Tech support and they suggested
copy, doesn't work, and pro*c, but had no example that works.