OraFAQ Forum: Windows » Using KEEP LAST in ASP

Home » Infrastructure » Windows » Using KEEP LAST in ASP

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 00:38:28 CST 2024