Re: SQL Plus and LONG datatype

From: Quinton McCombs <quintonm_at_bellsouth.net>
Date: 1998/02/27
Message-ID: <34F732A0.FA7BD54C@bellsouth.net>#1/1

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!
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Fri Feb 27 1998 - 00:00:00 CST