In message <1165838884.098500.319180_at_f1g2000cwa.googlegroups.com>, Loial
<admin_at_loial.co.uk> writes
>Anyone using the isql Viewer open source tool to connect to oracle 9 or
>10?
>
>isql viewer does not seem to like the backslash in the insert code
>below, giving the following error.
>
>SQLException :: (ORA-00911: invalid character, sqlcode=911,
>sqlstate=42000)
>
>'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890()_+-=:~./\',
>
It is possible that the \ is being interpreted as an escape character
and therefore the closing ' is being treated as part of the string and
not the string terminator. Try ...:~,/' || chr(whatever the ascii value
of \ is)
--
Jim Smith
Ponder Stibbons Limited <http://oracleandting.blogspot.com/>
RSS <http://oracleandting.blogspot.com/atom.xml>
Received on Mon Dec 11 2006 - 06:58:48 CST
