The "SP2" error messages are messages issued by SQL*Plus. The SP2-0678 error message text is "Column or attribute type can not be displayed by SQL*Plus." What you probably tried to do is to dump a binary data type, i.e. BLOB, to the screen in SQL*Plus. The problem is that SQL*Plus can only handle text data. It cannot handle binary data. Therefore, you are getting an error message telling you that this data type can not be displayed in your SQL*Plus session. Try your SELECT statement again but eliminate the BLOB column(s) from your query.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.