ORA-00911: invalid character error while executing a query

Question

select salution||' '||firstname||' '||lastname as custName , city as custCity ,state as custState,zip as custZip, dob as custDob ,idhardtoken as custAdarNo from mstuser ;

For the above query I am getting the oracle error ORA-00911: invalid character error while executing a query from java class file. What will be the correction for it ?

Was this query copied from a .doc or .docx file or something like that ? — Eduard Uta, Mar 24 '16 at 11:11
Is this the actual query which caused the error? I don't see any problem with the concatenation. — Tim Biegeleisen, Mar 24 '16 at 11:12

score 2 · Accepted Answer · answered Mar 24 '16 at 11:29

An SQL statement does not include a trailing semicolon. That is used as a statement separator in SQL*Plus and other clients (though even there you can change that to a different character), and it is not part of the statement itself. (PL/SQL requires semicolons as separators, but that's off-topic).

When you're running the statement over JDBC you should not include the semicolon. You should just be running

"select salution||' '||firstname||' '||lastname as custName, "
    + "city as custCity, state as custState, zip as custZip, "
    + "dob as custDob, idhardtoken as custAdarNo from mstuser"

(split just to show it without sideways scrolling...)

Thanks Alex for the knowledge you shared. – Shuvajit Ghosh Mar 31 '16 at 12:43 — Shuvajit Ghosh, Mar 31 '16 at 12:43

ORA-00911: invalid character error while executing a query

1 Answers1