RE: Antw: RE: Insert > 8000 Byte into LONG column

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Wed, 16 Jul 2003 12:25:00 -0400
Message-Id: <25937.338082@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------=_NextPartTM-000-de027ace-1ab8-4621-adf0-7ce5af05fae1 Content-Type: multipart/alternative;

boundary="----_=_NextPart_001_01C34BB6.CDC9D616"

------_=_NextPart_001_01C34BB6.CDC9D616
Content-Type: text/plain;

charset="iso-8859-1"

You could create a temp blob, use dbms_lob to add your text to it and then maybe update the column ?? Look at dbms_lob package.

Raj

Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !

-----Original Message-----
From: Guido Konsolke
[mailto:Guido.Konsolke_at_tkserv-triaton.thyssenkrupp.com] Sent: Wednesday, July 16, 2003 12:25 PM
To: Multiple recipients of list ORACLE-L Subject: Antw: RE: Insert > 8000 Byte into LONG column

Hi Tom,

thanks for trying to help. Unfortunately I have no chance because I've no account with write permissions. So it seems impossible to put the data on the server through ftp. Oh: and (of course!) no UTL_FILE_DIR defined in the init...ora.

Any other suggestions?

tia,
Guido

>>> NDATFM_at_labor.state.ny.us 16.07.2003 17.34 Uhr >>> Guido,

Can you use utl_file for this within a PL/SQL block?????

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
[mailto:Guido.Konsolke_at_tkserv-triaton.thyssenkrupp.com] Sent: Wednesday, July 16, 2003 9:54 AM
To: Multiple recipients of list ORACLE-L

Hi dear list members,

we run a database 8.1.6.2
I've run into a problem. I've got a table that contains a LONG column (I know, I know). I have to insert a string into it that has a length > 8500 Byte. Whenever I issue the insert statement SQL/PLUS throws the error 'ORA-01704: string literal too long'.

Does anyone have an idea how I can get the data into the table?

Any help (except: change the datatype ;-)) is appreciated.

Greetings,
Guido

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Guido Konsolke
INET: Guido.Konsolke_at_tkserv-triaton.thyssenkrupp.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Mercadante, Thomas F
INET: NDATFM_at_labor.state.ny.us

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Guido Konsolke
INET: Guido.Konsolke_at_tkserv-triaton.thyssenkrupp.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

------_=_NextPart_001_01C34BB6.CDC9D616
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2654.19">

<TITLE>RE: Antw: RE: Insert &gt; 8000 Byte into LONG column</TITLE>
</HEAD>
<BODY>

You could create a temp blob, use dbms_lob to add = your text to it and then maybe update the column ?? Look at dbms_lob = package.

Raj
 <FONT =

SIZE=3D2>---------------------------------------------------------------=
-----------------</FONT>

Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly = personal.
 QOTD: Any clod can have facts, having an opinion is = an art !

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Guido Konsolke</FONT>
<BR><FONT SIZE=3D2>[<A =

HREF=3D"mailto:Guido.Konsolke_at_tkserv-triaton.thyssenkrupp.com">mailto:Gu= ido.Konsolke_at_tkserv-triaton.thyssenkrupp.com</A>]

<BR><FONT SIZE=3D2>Sent: Wednesday, July 16, 2003 12:25 PM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: Antw: RE: Insert &gt; 8000 Byte into LONG =

column

Hi Tom,

thanks for trying to help. Unfortunately I have no = chance
 because I've no account with write permissions. So = it

<BR><FONT SIZE=3D2>seems impossible to put the data on the server =
through ftp.</FONT>
<BR><FONT SIZE=3D2>Oh: and (of course!) no UTL_FILE_DIR defined in the =

init...ora.

Any other suggestions?

<P><FONT SIZE=3D2>tia,</FONT>
<BR><FONT SIZE=3D2>Guido</FONT>
</P>

>>> NDATFM_at_labor.state.ny.us = 16.07.2003  17.34 Uhr >>> Guido,

Can you use utl_file for this within a PL/SQL = block?????

<P><FONT SIZE=3D2>Tom Mercadante</FONT>
<BR><FONT SIZE=3D2>Oracle Certified Professional</FONT>
</P>
<BR>

-----Original Message----- [<A =
HREF=3D"mailto:Guido.Konsolke_at_tkserv-triaton.thyssenkrupp.com">mailto:Gu= ido.Konsolke_at_tkserv-triaton.thyssenkrupp.com</A>]

<BR><FONT SIZE=3D2>Sent: Wednesday, July 16, 2003 9:54 AM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
</P>
<BR>

Hi dear list members,

we run a database 8.1.6.2

<BR><FONT SIZE=3D2>I've run into a problem. I've got a table =
that</FONT>
<BR><FONT SIZE=3D2>contains a LONG column (I know, I know).</FONT>
<BR><FONT SIZE=3D2>I have to insert a string into it that has a length =

> 8500 Byte.
 Whenever I issue the insert statement SQL/PLUS = throws
 the error 'ORA-01704: string literal too = long'.

Does anyone have an idea how I can get the = data
 into the table?

Any help (except: change the datatype ;-)) is = appreciated.

<P><FONT SIZE=3D2>Greetings,</FONT>
<BR><FONT SIZE=3D2>Guido</FONT>
</P>

-- 
 Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.net" =
TARGET=3D"_blank">http://www.orafaq.net</A>

<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Guido Konsolke</FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: =

Guido.Konsolke_at_tkserv-triaton.thyssenkrupp.com

Fat City Network Services    -- = 858-538-5051 <A HREF=3D"http://www.fatcity.com" = TARGET=3D"_blank">http://www.fatcity.com</A> San Diego, =
California        -- Mailing list = and web hosting services
 <FONT =

SIZE=3D2>---------------------------------------------------------------=

------
 To REMOVE yourself from this mailing list, send an = E-Mail message
 to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in
 the message BODY, include a line containing: UNSUB = ORACLE-L
 (or the name of mailing list you want to be removed = from).  You may
 also send the HELP command for other information = (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.net" =
TARGET=3D"_blank">http://www.orafaq.net</A>

<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Mercadante, Thomas F</FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: NDATFM_at_labor.state.ny.us </FONT>
</P>

SIZE=3D2>---------------------------------------------------------------=

-- 
 Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.net" =
TARGET=3D"_blank">http://www.orafaq.net</A>

<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Guido Konsolke</FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: =

Guido.Konsolke_at_tkserv-triaton.thyssenkrupp.com

Fat City Network Services    -- = 858-538-5051 <A HREF=3D"http://www.fatcity.com" = TARGET=3D"_blank">http://www.fatcity.com</A> San Diego, =
California        -- Mailing list = and web hosting services
 <FONT =

SIZE=3D2>---------------------------------------------------------------=

</BODY>
</HTML>
------_=_NextPart_001_01C34BB6.CDC9D616--

------=_NextPartTM-000-de027ace-1ab8-4621-adf0-7ce5af05fae1 Content-Type: text/plain;

name="ESPN_Disclaimer.txt"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;

filename="ESPN_Disclaimer.txt"

*********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************1

Received on Wed Jul 16 2003 - 11:25:00 CDT