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!

How to convert long to Number

Darthvader-647181Aug 2 2011 — edited Aug 2 2011

Hi,
I am trying to execute the below query and it retruns an error.

SELECT max(high_value)
		FROM   all_tab_partitions
		WHERE  table_name ='BA_CURRENT_MONTH'

Error:
ORA-00997: illegal use of LONG datatype

when i try to convert the long to to_char,to_number,substr,trim ,to_lob etc, it gives me the below error:
ORA-00932: inconsistent datatypes: expected - got LONG

Please help.
Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 30 2011

Added on Aug 2 2011

4 comments

8,606 views