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: OraOLEDB.Oracle driver of 10g with C++
Next Topic: installatin of oracle 9i second Oracle_Home on windows 2003 stops abnormally
Goto Forum:

Current Time: Sun Aug 20 23:43:32 CDT 2017

Total time taken to generate the page: 0.00904 seconds