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

Thread: Problem with BLOB

  1. #1
    Join Date
    Mar 2001
    Location
    India
    Posts
    57
    Hello friends,

    Hello everybody.I am working in a bank as a DBA.I am facing a problem with a table containing BLOB datatype.There is a table of our customer signature.That table have following columns......

    AC_TPY varchar2(3) (Account tpye like savings,current etc)
    AC_NO varchar2(5) (Account Number of Customer)
    BR_CODE varchar2(3) (Our bank's branch code)
    SIG blob (Signature of that customer)

    Now probelm is that whenever I tried to insert rows from SQLLOADER all data loads data.But when we retriving data from table thro' fronend it will shows data in first three columns but for forth it shows there is no data found(It is heppened for very few rows).Problem is this how can I should now from direct SQL or some other utilites that my column
    has a data or not.Because I want to delete same data and will insert another time.

    How can I know that column containing BLOB have data or not?

    Please tell and guide me.

    Thanks for tring to help or guide me in advance.

    Regards,
    Gitesh Trivedi.
    DBA


  2. #2
    Join Date
    Jan 2002
    Posts
    152
    Hi Gitesh,there's no way to view BLOB data with SQL*Plus or any Oracle interface.You need to try withany other utility throw Visual Basic,Java or any other method.
    You can convert BLOB to Long or varchar2(4000) for example,and you could see the data code( I can imagine you handle images).
    Hope that helps.Regards

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