DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Hybrid View

  1. #1
    Join Date
    Feb 2000
    New York,U.S.A.
    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.

  2. #2
    Join Date
    Dec 2000
    To the Oracle8 Server, a LOB's value is unstructured and cannot be queried against. You have to use dbms_lob package to read BLOB. Read Metalink Document 61737.1 for more detail.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.