Re: HOW do I load data with semicolons

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Wed, 02 Feb 2000 22:49:19 GMT
Message-ID: <3898b45c.3051023@news.earthlink.net>

no guarantees, but try using doublequotes

On Wed, 02 Feb 2000 14:23:37 -0600, Robert walkup <rdww_at_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_at_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

Received on Wed Feb 02 2000 - 16:49:19 CST