isql viewer

From: Loial <admin_at_loial.co.uk>
Date: 11 Dec 2006 04:08:04 -0800
Message-ID: <1165838884.098500.319180@f1g2000cwa.googlegroups.com>

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)

Can I resolve this problem in isql viewer without changeing the sql? If I have tried the isql support forum, but there has been no response.

I do not get this error if I use oracle's own SQL Worksheet

DELETE FROM PRINTER_TYPE_PARAMETERS WHERE PRINTER_TYPE = 'JES_DUPLEX'; INSERT INTO PRINTER_TYPE_PARAMETERS (
PRINTER_TYPE,

PARAMETER_NAME,
PARAMETER_TYPE,
PARAMETER_DESCRIPTION,

REQUIRED,
CANNOT_CHANGE_ONCE_ENTERED,
MUST_BE_UNIQUE,
MUST_BE_UNIQUE_GROUP,
CREATE_DIRECTORY,
VALID_CHARACTERS,
MAX_LENGTH,
DEFAULT_VALUE,
CHANGEABLE
)
VALUES (
'JES_DUPLEX',
'PID',
'PRINTER',
'Printer ID',
'Y',
'N',
'Y',
'N',
'N',
'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890()_+-=:~./\',

10,
NULL,
'Y'

);    

COMMIT; Received on Mon Dec 11 2006 - 06:08:04 CST