SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Inserting Text with Quotation Marks and Apostrophes

447542Aug 30 2005 — edited Aug 31 2005

All-

I'm working on customizing Outlook to capture all e-mail messages and plop them into a history table.

Everything works great except for the insert statement that I generate. When I put the body of the e-mail into the statement, it ends up crashing the program nearly every time.

The cause of which is the ", ', and , that appear within the body of the message. Is there anyway that I can insert this data? Like a verbatim string character or something?

These symbols are things that need to be kept, not something to just get rid of.

Thanks,

Adam

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 28 2005

Added on Aug 30 2005

11 comments

387 views