Problem with q quoting in command window

[Lukasz Indeka]

Hi,

Query:

SELECT q'[Frank's Oracle site]' AS text FROM DUAL;

in SQL Window works as it supposed to work. In Command Window however one gets:

SQL> SELECT q'[Frank's Oracle site]' AS text FROM DUAL;
  2  /

SELECT q'[Frank's Oracle site]' AS text FROM DUAL;

ORA-00911: invalid character

SQL>

Queries listed bellow works well in both windows:

SELECT q'[A 'quoted' word.]' AS text FROM DUAL;
SELECT q'[A ''double quoted'' word.]' AS text FROM DUAL;

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0
PL/SQL Developer 9.0.1.1613

Best regards,
Lukasz Indeka

 

[Marco Kalter]

It seems that the command-line parser stumbles on the q quote when there is a single quote in the string. We'll fix it.