SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00997: illegal use of LONG datatype

537163Oct 10 2011 — edited Oct 10 2011

Hi

i try to retrieve datas from my table but i have an error ora-00997

Desc VISIT_ACTVT

Column Name Data Type
L_VISIT_ACTVT_ID VARCHAR2 (15 Byte)
L_VST_ID VARCHAR2 (15 Byte)
L_VST_SUJET VARCHAR2 (3 Byte)
L_VST_PROPOS_CLT VARCHAR2 (254 Byte)
L_VST_REACTION VARCHAR2 (1 Byte)
OPPORTUNITY_ID VARCHAR2 (15 Byte)
ROW_ADDED_DTTM DATE
ROW_ADDED_OPRID VARCHAR2 (30 Byte)
ROW_LASTMANT_DTTM DATE
ROW_LASTMANT_OPRID VARCHAR2 (30 Byte)
SYNCID INTEGER
SYNCDTTM DATE
L_VST_COMMENT LONG

Query
select
L_VST_ID
, ROW_ADDED_DTTM
, ROW_ADDED_OPRID
, MAX(PBVA.ROW_ADDED_DTTM) keep (DENSE_RANK LAST ORDER BY PBVA.ROW_ADDED_DTTM) max_row_dttm
, MAX(PBVA.ROW_ADDED_OPRID) keep (DENSE_RANK LAST ORDER BY PBVA.ROW_ADDED_DTTM) max_row_oprid
, MAX(PBVA.L_VST_COMMENT) keep (DENSE_RANK LAST ORDER BY PBVA.ROW_ADDED_DTTM) max_row_oprid
from VISIT_ACTVT PBVA
group by
L_VST_ID
, ROW_ADDED_DTTM
, ROW_ADDED_OPRID

How can i retrieve a long datatype ,

thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 7 2011

Added on Oct 10 2011

4 comments

23,335 views