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.
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
Click Here to Expand Forum to Full Width