Re: Getting first row problem...oracle 8i standard.

In article <sSY37.29576$WS4.4550743_at_news6-win.server.ntlworld.com>, "Matthew says...
>
>Dear all,
>
>
>I am trying to write a view that returns a value in the first row (within a
>stored procedure)...
>
>select first myvalue into nValue from tblX order by Y.
>
>
>I have tried using
>
>select FIRST_ROW(myvalue) over (order by x) from tblx order by x.
>

execute immediate
'select myvalue from ( select myvalue from tablX order by y ) where rownum = 1' into nValue;

>
>However I get a not supported error OLAP error. I have tried installing
>OLAP...still the same error.
>
>How do I return a value from the first row of an ordered recordset?
>
>
>
>Thanks.
>
>
>Matt.
>
>

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp