what is error sp2-0678?
what is the meaning of sp2-0678 oracle error? question posed on: 13 jan 2004
question answered by: brian peasland 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.