instruction Case in SQL

[vpv]

i write follow instruction :
CURSOR DL (dt1 DATE,dt2 DATE) IS
select ipcrcard, dpcrsdt, dpcrfdt, ipcracc,
f.ccknname, h.cognsname,
case when cognsname is null then 'natural person' else cognsname end,ccusname,cncrhtp
from dfc, trm.....

but show error: "encountered symbol CASE, when expecting..."

Why?

 

[sem]

What is your database version? This construct was introduced in 8i.

Regards, Dima

http://seminihin.narod.ru

 

[vpv]

hm... 8.1.7.4 version...

 

[sem]

8i PL/SQL doesn't support it. You may open cursor dynamically (REF CURSOR).

Regards, Dima

http://seminihin.narod.ru