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
posted 14 years ago
Error : java.sql.SQLException : General error
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.