LONG want to convert to VARCHAR

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. Received on Wed Jul 07 1993 - 09:32:56 CEST