Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

ORA-00997: illegal use of LONG datatype at OCI call OCIStmtExecute. [nQSError: 17010] SQL statement

Received Response

1

Views

1

Comments

3174977

3174977 Rank 5 - Community Champion

Aug 18, 2016 5:54AM edited Aug 13, 2024 6:13PM in Oracle Analytics Cloud and Server

Hi All,

I have a column in database with datatype as long . In OBIEE how to handle this kind of columns.

Thanks !

0

Answers

SriniVEERAVALLI Rank 6 - Analytics Lead

Aug 18, 2016 8:56AM

Convert it to near datatype so that you wont loose data. So that you can use that in your Group by clause

0