&(ampersand) problem
673082Nov 30 2008 — edited Dec 1 2008I have a problem in inserting record where backend is oracle and front end is visual basic. When user inputs "*+&+*"(ampersand) symbol in textbox and the code tries to insert the record as it is, an error is generated. As far as i know "*+&+*" refers to the input symbol, but i want to escape the "*+&+*" symbol and insert the record without any problem. Is there anyway it can be done?. Does oracle/sql provides any function that can be used to escape certain reserved characters.