Invalid characters

gregoryliss · Post by **gregoryliss** » Sun 16 Jul 2006 19:25

Is it possible for ODAC to handle the following:

SELECT q'' FROM DUAL

without tossing an Invalid Character exception?

Plash · Post by **Plash** » Mon 17 Jul 2006 13:17

We cannot reproduce the problem. This query has incorrect syntax. So it cannot be executed without exception.

gregoryliss · Post by **gregoryliss** » Tue 18 Jul 2006 09:52

Below is the output from SQL*Plus on a 10.2 instance:

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jul 18 05:50:20 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> SELECT q'' FROM DUAL
2 /

Q'
--------------------------------
'So,' she said, 'It's finished.'

SQL>

Plash · Post by **Plash** » Wed 19 Jul 2006 14:35

We cannot reproduce the problem. TOraQuery component opens this SQL successfully when using Oracle 10.2 client against Oracle 10.2 database. Please specify the situation more detailed.

Devart Forums

Invalid characters

Invalid characters

Valid for 10.2