Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: nvl2() can not be used in a cursor?
Alternative is to use dbms_sql to parse the statement and fetch data from
resulting cursor - dbms_sql provides access to SQL engine, which obviously
supports this function.
-- Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications. All opinions are mine and do not necessarily go in line with those of my employer. "Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message news:E2F6A70FE45242488C865C3BC1245DA70294B4C2_at_lnewton.leeds.lfs.co.uk...Received on Fri Aug 30 2002 - 13:23:53 CDT
> Jochen,
>
> NVL2 is only available in SQL*Plus, not in PL/SQL yet :o(
> It is available in PL/SQL in 9i release 2. (9.2.0)
>
> Cheers,
> Norman.
>
> -------------------------------------
> Norman Dunbar
> Database/Unix administrator
> Lynx Financial Systems Ltd.
> mailto:Norman.Dunbar_at_LFS.co.uk
> Tel: 0113 289 6265
> Fax: 0113 289 3146
> URL: http://www.Lynx-FS.com
> -------------------------------------
>