Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to save LONG RAW to file

Re: How to save LONG RAW to file

From: Sebastian Bienkiewicz <bienkiew_at_bph.krakow.pl>
Date: Tue, 27 Apr 1999 15:05:11 +0200
Message-ID: <3725B607.EC0F5AD8@bph.krakow.pl>


You can, but not in a sqlplus.

Peizhong Wu wrote:
>
> Sebastian Bienkiewicz wrote:
>
> > In that way it's impossible, 'cause SQL*Plus tries to covert LONG RAW to
> > 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;
>
Received on Tue Apr 27 1999 - 08:05:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US