Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> HOW do I load data with semicolons

HOW do I load data with semicolons

From: Robert walkup <rdww_at_scdba.sc.ti.com>
Date: Wed, 02 Feb 2000 14:23:37 -0600
Message-ID: <38989249.8144D4C1@scdba.sc.ti.com> 





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
Received on Wed Feb 02 2000 - 14:23:37 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US