Home » Infrastructure » Windows » Using KEEP LAST in ASP
Using KEEP LAST in ASP [message #190291] Wed, 30 August 2006 01:32
Messages: 1
Registered: August 2006
Location: Melbourne, Australia
Junior Member

I am having a problem using KEEP LAST in ASP and Oracle It runs fine in PL/SQL Developer and SQL Plus. The SQL command is below.

SELECT MAX(comment_text) KEEP (DENSE_RANK LAST ORDER BY DECODE(comment_source, 'V', 2, 'M', 1, 0), create_date)
FROM dispute_comment where dispute_history_id = 649992

I got this error when running through ASP.

OraOLEDB error '80040e14'
ORA-02000: missing DENSE_RANK

Thanks for your help.


Previous Topic: ODBC-error 'ORA-12535: TNS:operation timed out' when trying to connect to Oracle 9.2.0
Next Topic: Oracle 8i on Windows XP: ORA-01034
Goto Forum:

Current Time: Sat Nov 27 00:01:31 CST 2021