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: inserting into long data types

Re: inserting into long data types

From: Joseph Bonner <jbonner_at_mmg.im.med.umich.edu>
Date: Sun, 19 Apr 1998 19:05:25 GMT
Message-ID: <3539A32A.CC24586F@mmg.im.med.umich.edu>


To insert into long data types you have to use SQL loader. There are demo programs in
$ORACLE_HOME/server/doc/SUT73/ch4.htm#case1

Phil Notick wrote:

> Is there a way to insert textual information larger than 1000 characters
> into
> a long data type using a sql*plus insert statement?
> I run into the ORA-1704 error, I have played with linesize and long
> parameters to no avail.
>
> ------------------------------------------------------------------------
>
> Phil Notick <Phil_at_newscorp.com>
> System Architect
> NIS
>
> Phil Notick
> System Architect <Phil_at_newscorp.com>
> NIS HTML Mail
> Netscape Conference Address
> Netscape Conference DLS Server
> Additional Information:
> Last Name Notick
> First Name Phil
> Version 2.1
Received on Sun Apr 19 1998 - 14:05:25 CDT

Original text of this message

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