How to view BLOB data
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How to view BLOB data

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