Unable to send the results of an Oracle query, which includes the Prime () symbol, to local storage. The following error is displayed:
"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near"...
WORKAROUND
If Prime symbol was used in error (instead of an apostrophe), use the Transform & Cleanse module to replace the character, then send to local storage.
STATUS
Waiting for fix in a future release of Toad Data Point.