Page 1 of 1
Invalid characters
Posted: Sun 16 Jul 2006 19:25
by gregoryliss
Is it possible for ODAC to handle the following:
SELECT q'' FROM DUAL
without tossing an Invalid Character exception?
Posted: Mon 17 Jul 2006 13:17
by Plash
We cannot reproduce the problem. This query has incorrect syntax. So it cannot be executed without exception.
Valid for 10.2
Posted: Tue 18 Jul 2006 09:52
by gregoryliss
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>
Posted: Wed 19 Jul 2006 14:35
by Plash
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.