I am getting the following error when i execute the following line. rs = stmt.executeQuery("SELECT FILEDATA FROM TMPBLOB WHERE FILENAME='test.jpg' FOR UPDATE"); where FILEDATA is of type BLOB. Error : java.sql.SQLException : General error when i try the following Select query on SQL prompt SELECT FILEDATA FROM TMPBLOB; I get the error message : Column or attribute type can not be displayed by SQL*Plus why this should happen ?? thank you. Padmanabh
Could you please describe this more? may be a printStackTrace will help. I also get the same error in SQL plus, i think it cannot display binary data types.
I can't renounce my name. It's on all my stationery! And hinted in this tiny ad:
a bit of art, as a gift, the permaculture playing cards