Sql terminator ; in q syntax query block

From: Michael D O'Shea/Woodward Informatics Ltd <woodwardinformatics_at_strychnine.co.uk>
Date: Wed, 17 Mar 2021 18:30:38 +0000
Message-Id: <6D10EFBB-ABC2-49AC-A3CE-8E309D3F141C_at_strychnine.co.uk>

Hi chaps, it’s an anonymised example but does represent an ongoing issue I have at the moment.

Other than replacing the semicolon with another character, does anyone know whether the SQL terminator can be turned off? There is nothing obvious showing up with a „help set“ in sqlplus. I am surprised that this is even an issue given the multiline string is inside a q syntax block, but it is.

Mike
http://www.strychnine.co.uk <http://www.strychnine.co.uk/>

SQL>
SQL>
SQL>
SQL> select q'[A,B,C,D;

ERROR:
ORA-01756: quoted string not properly terminated    

SQL> E,F,G,H;
SP2-0042: unknown command "E,F,G,H" - rest of line ignored. SQL> I,J]' x
SQL> from dual;
SP2-0042: unknown command "from dual" - rest of line ignored.

SQL>
SQL>
SQL>
SQL>
SQL>
SQL> select banner from v$version;
 

BANNER

---

Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production  

SQL>
--

http://www.freelists.org/webpage/oracle-l Received on Wed Mar 17 2021 - 19:30:38 CET