Xref: alice comp.databases.oracle.server:83112
Path: alice!news-feed.fnsi.net!news-FFM2.ecrc.net!news.mindspring.net!cabal10.airnews.net!news.airnews.net!cabal11.airnews.net!news.airnews.net!news.smu.edu!news.ti.com!not-for-mail
From: Robert walkup <rdww@scdba.sc.ti.com>
Newsgroups: comp.databases.oracle.server
Subject: HOW do I load data with semicolons
Date: Wed, 02 Feb 2000 14:23:37 -0600
Organization: Texas Instruments Incorporated
Lines: 19
Message-ID: <38989249.8144D4C1@scdba.sc.ti.com>
Reply-To: rdww@scdba.sc.ti.com
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: tilde.csc.ti.com 949522837 19931 156.117.67.84 (2 Feb 2000 20:20:37 GMT)
X-Complaints-To: usenet@news.ti.com
NNTP-Posting-Date: 2 Feb 2000 20:20:37 GMT
X-Sender: "Robert walkup" <rdww@scdba.sc.ti.com> (Unverified)
X-Mailer: Mozilla 4.04 [en]C-TexIns  (WinNT; I)

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