select '§' from dual; produces ORA-01756 error

From: David McMeans <googlenews_at_fhg.mailshell.com>
Date: 11 Feb 2004 13:33:23 -0800
Message-ID: <d3865bef.0402111333.cf13911@posting.google.com>

I've got two 9i databases. One was upgraded from 8.1.7 and the other created from scratch.

In looking at the database parameters, the only significant difference is the compatible setting, which for the upgraded one is still at 8.1.7, while the other is at 9.2.0.0.0.

In the "from scratch" database, if I enter

select '§' from dual;

in SQLPlus, I get

select '§' from dual

       *
  ERROR at line 1:
  ORA-01756: quoted string not properly terminated

The same sql works fine in the upgraded database. Any idea what's going on here?

Thanks,

David Received on Wed Feb 11 2004 - 15:33:23 CST