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: SQL Plus and LONG datatype

Re: SQL Plus and LONG datatype

From: David Ng <davidng_at_chevalier.net>
Date: 1998/03/01
Message-ID: <01bd4469$2c5402c0$45034dca@default>#1/1

Try PS/SQL, it works

Quinton McCombs <quintonm_at_bellsouth.net> wrote in article <34F732A0.FA7BD54C_at_bellsouth.net>...
> You might be able to accomplish the with the utl_file package. This
> will let you write directly to an operating system file.
>
> yaffer_at_hotmail.com wrote:
> >
> > I need to run a sqlplus script to write the contents of a LONG column
 to a
> > file. In my script I spool to a file and then execute a stored
 procedure that
> > DBMS_OUTPUTs the LONG column. But the DBMS_OUTPUT returns an error -- I
 guess
> > it can't handle a LONG.
> >
> > Are there ways to do this without any 3rd party tools? This is a script
 to be
> > executed from SQLPlus -- it does not have an application calling it.
 If I do
> > need 3rd party tools, what are some options? Thanks!
> > s
> > -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> > http://www.dejanews.com/ Now offering spam-free web-based newsreading
>
  Received on Sun Mar 01 1998 - 00:00:00 CST

Original text of this message

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