Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Location
    Bangalore, India
    Posts
    4

    Unanswered: problem with blob

    Hi,

    When I tried this query select * from table_name,
    I am getting this error
    SP2-0678: Column or attribute type can not be displayed by SQL*Plus

    The table contains BLOB field. I need the content of that field also.
    Can you please help me???

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    You could use DBMS_LOB.SUBSTR to display the BLOB column. But BLOBs are not formatted (by definition) and so you will not see anything meaningful in SQL Plus: it needs to be interpreted by some kind of program.

Posting Permissions

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