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

From: Matthew Barrett <matt_barrett_at_tesco.net>
Date: Sat, 14 Jul 2001 15:49:10 +0100
Message-ID: <sSY37.29576$WS4.4550743@news6-win.server.ntlworld.com>

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.

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. Received on Sat Jul 14 2001 - 09:49:10 CDT