CODEWITHSUNDEEP
javajdbcoracle11g
sweet dreams
sweet dreams

Reputation: 2134

A simple create user statement fails?

Like before, making Java-Oracle11g-JDBC (OJDBC) code. Java code tries to do an executeUpdate() on the statement below and an error occurs. But Oracle 11g executes it without any problems(via its GUI).

Statement-

 CREATE USER Person identified by 2012;

Error (ie A part of PrintStackTrace) - 

java.sql.SQLSyntaxErrorException: ORA-00911: invalid character

Upvotes: 1

Views: 197

Answers (1)

Jon Lin
Jon Lin

Reputation: 143946

Oracle doesn't like the semicolon at the end. You don't want semicolons in your OJDBC queries, eventhough it works from the Oracle GUI.

Upvotes: 3

Related Questions