Add Null value to cursor

[Bert de Nooij]

Hi all,


In a cursor (Oracle)  I would like to add an extra column with value "NULL"

As NULL is a reserved word I need to enclose it in double quotes ( Yes,I did
RTFM!)
However PH keep complaining that the column cannot be found.

sql in AL_DB declare CURSOR_TEST cursor for          &
select CONTRACTNR , NAWNR , "NULL" as test           &
  from CONTRACT_GEG                                  &
 where CONTRACTNR = 2002017030

access CURSOR_INVERZEKERING

*E* Error parsing SQL statement.
DMS-E-GENERAL, A general exception has occurred during operation 'prepare
request'.
DMS-E-RBI_COLUMN, Column NULL was not found.


When I do this directly in SQL there is no problem.

Any suggestions?

Bert de Nooij