Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Help with error: An internal error; Blob is null
Hi,
I'm trying to write Java application to insert rows to the table in my Personal Oracle Lite DB. This table include a column with "LONG" type because one character string can exceed more than 2000 chars.
When I use "PreparedStatement" class in Java JDBC libraries, it throws a SQLException with "POL-5195: An internal error; Blob is null". I really wonder why this is happening and if someone can give me any insight.
If I hardcode PreparedStatement like;
PreparedStatement testStmt = con.prepareStatement ("INSERT INTO MTUBE
(PID, NAME, ANOTHERNAME, BEGLOC, ENDLOC, LENGTH, STRAND, PRODUCT,
SEQUENCE) VALUES ('T','e','st',1,2,3,'T','s','t')");
testStmt.executeUpdate();
It works!!
But once I use "set" functions like;
PreparedStatement loadDataStmt = con.prepareStatement("INSERT INTO MTUBE
(PID, NAME, ANOTHERNAME, BEGLOC, ENDLOC, LENGTH, STRAND, PRODUCT,
SEQUENCE) VALUES (?,?,?,?,?,?,?,?,?)");
loadDataStmt.setString(1, "1A"); loadDataStmt.setString(2, "GENE"); loadDataStmt.setString(3, "GENE2"); loadDataStmt.setInt(4, 10); loadDataStmt.setInt(5, 20); loadDataStmt.setInt(6, 5); loadDataStmt.setString(7,"+" ); loadDataStmt.setString(8, "A+"); loadDataStmt.setString(9, "TAKAHASHI"); loadDataStmt.executeUpdate();
It throws an exception with that message.
I really appreciate any insight into this problem. Thanks in advance!
Kei Received on Wed Sep 08 1999 - 15:01:21 CDT
![]() |
![]() |