Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> How to save LONG RAW to file
I have a table with two columns:
doc_name varchar2(20)
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 - 04:20:57 CDT
![]() |
![]() |