Parser chokes on apostrophe

[Helge]

We are on PLSQL Developer release 9.0.3.1641.

We have a view that we use to create readable column headings for spreadsheet exports. One of the column labels in the view contains an apostrophe. The view compiles without error:

CREATE VIEW userfriendly AS
SELECT t.col1 "My Column"
      ,t.col2 "Dad's Column"
FROM   tab1 t

Normally we use this view as follows:

SELECT uf."My Column"
      ,uf."Dad's Column"
FROM   userfriendly uf
JOIN   tab2 t
ON     t.col1 = uf."My Column"
AND    t.col2 = 'Filter1'

However, since this latest release that no longer works. When we try that code in other environments, e.g. Toad or Oracle's SQL Developer, it works fine.

The problem seems to have something to do with how apostrophes are handled now. If we comment out the SELECT column with the apostrophe, the query works. If we comment out the filter for tab2 the query works.

We have found a work-around by putting the select from the userfriendly view into a WITH clause, but we'd like this to work correctly without work-around. Thanks.
--
Helge Moulding
University of Utah Development
Information Services

 

[Marco Kalter]

What exactly goes wrong? Any error messages? It works fine when I try it.

 

[Helge]

You're right, the minimalist case I presented to you does seem to work.

We get an ORA-00911 error.

I'm going to try to come up with a minimalist case that does duplicate the error.
--
Helge