Xref: alice comp.databases.oracle.server:83147
Path: alice!news-feed.fnsi.net!nntp.msen.com!news.eecs.umich.edu!newsfeed.mathworks.com!newsfeed1.earthlink.net!nntp.earthlink.net!newsread2.prod.itd.earthlink.net.POSTED!not-for-mail
From: andreyNSPAM@bookexchange.net (NetComrade)
Newsgroups: comp.databases.oracle.server
Subject: Re: HOW do I load data with semicolons
Message-ID: <3898b45c.3051023@news.earthlink.net>
References: <38989249.8144D4C1@scdba.sc.ti.com>
X-Newsreader: Forte Free Agent 1.11/32.235
Lines: 31
X-Complaints-To: abuse@earthlink.net
X-Trace: newsread2.prod.itd.earthlink.net 949531759 216.112.254.233 (Wed, 02 Feb 2000 14:49:19 PST)
NNTP-Posting-Date: Wed, 02 Feb 2000 14:49:19 PST
Organization: EarthLink Network, Inc.
X-ELN-Date: Wed Feb  2 14:49:19 2000
Date: Wed, 02 Feb 2000 22:49:19 GMT

no guarantees, but try using doublequotes

On Wed, 02 Feb 2000 14:23:37 -0600, Robert walkup
<rdww@scdba.sc.ti.com> wrote:

>Hi..
>
>I need to load data with a semicolon at the end of a line. I am using
>the Oraperl/DBI interface. With SQLPLUS I can set SQLTERMINATOR off
>and perform the insert. However I am unable to do this using the
>Oraperl interface?
>
>Example
>
>insert into t1(c1) values ('XXXXXX;
>')
>/
>
>Anyone have any ideas on how to get around this with out removing the
>semicolon.
>
>Thanks&Best regards,
>Robert Walkup
>rdww@ti.com

---------------
In case I forgot to mention: 
We use Oracle 7.3.4 on Solaris 2.6, 2.7 boxes
---------------
Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 750-3630
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email