If there are any & symbol in your sql insert query value, replace it with &'||'. (In case if the query fails to run)
The & will be considered as beginning of variable name in Oracle SQL.
Note: This is only if the & symbol is inside quotes.
Eg:
Insert into temp values(2.’me&u’); è Insert into temp values(2.’me&’||’u’);
This entry was posted
on Apr 13, 2009
at Monday, April 13, 2009
and is filed under
Oracle
. You can follow any responses to this entry through the
comments feed
.