If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Threaded View

Hi, all
When I do the following statement, I get
SQL> select xmlbody from messagearchive;
SP2-0678: Column or attribute type can not be displayed by SQL*Plus
SQL> !oerr sp2 0678
00678, 0, "Column or attribute type can not be displayed by SQL*Plus\n"
// *Cause:
// *Action:
The datatype for xmlbody is BLOB
Could anyone tell me how to view BLOB data from sqlplus?
Thanks for help.