From garychauhan@hotmail.com Thu, 01 Feb 2001 06:09:52 -0800 From: "Gary Chauhan" Date: Thu, 01 Feb 2001 06:09:52 -0800 Subject: Inserting into Long Message-ID: MIME-Version: 1.0 Content-Type: text/plain Hi, I am loading data into Oracle table using a perl program. Table structure is ( Col1 Varchar2, Col2 Long ); What r the different ways to insert into Long field? I have a string of length more than 4000 characters. When I am using insert statement like insert into table values ('abcd','String of more than 4000 characters'); I am getting an error ora 01704. If someone has example code to insert into long field, I will appreciate that. Thanks, Gary _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Chauhan INET: garychauhan@hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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).