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

I am having a problem using KEEP LAST in ASP and Oracle 9.2.0.6.0. 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.

Regards,
Jit

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: Thu Mar 28 18:37:16 CDT 2024