Re: How to save LONG RAW to file

Sebastian Bienkiewicz wrote:

> In that way it's impossible, 'cause SQL*Plus tries to covert LONG RAW t=
o
> CHAR and this conversion products ORA-00932 error. You must create
> PL/SQL function and use UTL_RAW package to do this (see
> $ORACLE_HOME/rdbms/admin/utlraw.sql file for more details).
>
> Regards,
> Sebastian.

Can we just use the simple line like:

    v_longraw LONG RAW;
      SELECT document INTO v_longraw FROM my_table;

The sqlplus just give me an error.

>
>
> > doc_name varchar2(20)
> > document long raw
> >
> > This table is populated using a client application developed with Pow=
er
> > 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 conten=
t
> > of every file generated):
> > ERROR:
> > ORA-00932: inconsistent datatypes
> >
> > OS: UnixWare.
> > Oracle 7.2.2
Received on Mon Apr 26 1999 - 10:01:37 CDT