How to save LONG RAW to file

doc_name varchar2(20)
[Quoted] document long raw

This table is populated using a client application developed with Power Builder.
Every evening I need to save the contents of this table to disk. What follow is part of an Unix script I wrote:

for RIGA in `cat $sqlspl`
do
sqlplus -s $uspw <<+++ > $sqllog 2>&1
set heading off
set feedback off
set pagesize 0
spool $RIGA
SELECT document from table where doc_name = ‘$RIGA’ /
exit
+++
done

Where $sqlspl is a file containing the name of the files I need to generate.

Running this script I receive the following error (this is the content of every file generated):
ERROR:
ORA-00932: inconsistent datatypes

OS: UnixWare.
Oracle 7.2.2

Thanks in advance.
Marco Minio
m.minio_at_venis.it Received on Wed Apr 21 1999 - 11:20:57 CEST