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: HELP PLEASE! (A real newbie)

Re: HELP PLEASE! (A real newbie)

From: David Greensmith <david_at_green1.demon.co.uk>
Date: Sun, 09 Aug 1998 03:47:15 GMT
Message-ID: <35cd1b61.20704130@news.demon.co.uk>


Peter Giannopoulos <petergi_at_generation.net> wrote:

>I need to get SQLLOader to stuff lots of text into some field. I don't
>know what datatype to use. Varchar2 just can't handle the (varying)
>amouny of text.
>
>Can anyone help me?
>
>Thanks in advance.
>
>--
>-----------------------------------------------------------------------
>"Do not look to authority for truth - look to truth for authority."
>Yoshida Kenji Sensei - Yanagi Ryu Aiki Bugei
>
>Peter Giannopoulos
>generation.net
>Database & Web Applications Developer
>
>Ph: 514-845-5555 ext.218
>Fax: 514-845-5004
>ICQ# 1723017
>------------------------------------------------------------------------
If your text is less than 2000 characters in length, and doesn't contain quites ", then use the quotes " to delimit the text. This should solve the problem for you.

I hope this helps,

David
David Greensmith :-)
(david_at_green1.demon.co.uk) Received on Sat Aug 08 1998 - 22:47:15 CDT

Original text of this message

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