This content has been marked as final. Show 4 replies
Not sure, but I would guess its related to the single quotes or the semi-colon at the end so the: ' or ;
Remove the ; at the end of the query.
I have a similar invalid character error when I try running my sql statement. I am just trying to run "select sysdate FROM DUAL;" which works in the SQL Dev software but not in my java code, I get the same invalid character error. When I remove the ; at the end of the query I get the following error:
java.sql.SQLException: Closed Statement: next
Any idea how to solve this? Is there a prefix I should put in from of the semi colon?
Try getting an answer via the SQL Developer Forum.