SP2-0678 Column or attribute type can not be displayed by SQL*Plus

[Database Administrator]

Oracle Error : SP2-0678 Column or attribute type can not be displayed by SQL*Plus

Cause: The type specified is not supported.

Action: Rewrite the query to select the data with types that SQL*Plus supports.

[password]

By rewriting the query again still getting same error.
select * from employees; (not working)(Oracle 9i) whether others tables are working with this select * from locations; (working )(Oracle 9i)

Originally Posted by oracle dba

Oracle Error : SP2-0678 Column or attribute type can not be displayed by SQL*Plus

Cause: The type specified is not supported.

Action: Rewrite the query to select the data with types that SQL*Plus supports.

[administrator]

Originally Posted by password

By rewriting the query again still getting same error.
select * from employees; (not working)(Oracle 9i) whether others tables are working with this select * from locations; (working )(Oracle 9i)

Most probably you have a column thats either a blob, bfile etc in the table design. Describe your table and only select columns that you need to display on the screen.

So change the query to be select id, name, description from employees instead of select * from employees.