Skip to Main Content

Analytics Software

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!

double up quotes (apostrophe)

user1188419Sep 2 2010 — edited Sep 6 2010
Hello

I have a variable which contains a french string with a quote: L'experience....
This string could come from XML-File, text file or error messages.
How is it possible to double up the single quote to insert this string into a database?
A simple insert fails because the database does not accept this:
INSERT INTO xxx VALUES(#variable_name)

I found a technical document for ODI: ID 867906.1 but this document does not explain how to double up.

Any hints are appreciated.

Regards

Markus
This post has been answered by Ankit J on Sep 3 2010
Jump to Answer

Comments

amey g

Hello,

There was a rare case where the DataSource maintenance thread could hang. This is addressed by Bug 14169154 PSR: PERF : STUCK THREAD IN WEBLOGIC CHECK RESOURCEPOOL CALL.


Please check


Thanks,
Amey

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 4 2010
Added on Sep 2 2010
8 comments
1,997 views