Allen wrote: > I am using Python with cx_oracle to load an excel spreadsheet into an > Oracle table. There are lots of text on the spreadsheet that have "&" > in them which I want to keep in the table. But inserting those text > will fail.
Why do you say that? > Is there a work around for this? I can filter out the > failed insert statements and in SQLPLUS set define off to run those > statements, but it would be nice to insert "&" directly in PYTHON. > regards Steve -- Steve Holden +1 571 484 6266 +1 800 494 3119 Holden Web LLC http://www.holdenweb.com/ -- http://mail.python.org/mailman/listinfo/python-list
