Semicolon ; on the end of command had caused the same error on me.
cmd.CommandText = “INSERT INTO U_USERS_TABLE (USERNAME, PASSWORD, FIRSTNAME, LASTNAME) VALUES (”
+ “‘” + txtUsername.Text + “‘,”
+ “‘” + txtPassword.Text + “‘,”
+ “‘” + txtFirstname.Text + “‘,”
+ “‘” + txtLastname.Text + “‘);”; <== Semicolon in "" is the cause.
Removing it will be fine.
Hope it helps.
Oracle does not allow joining tables in an UPDATE statement. You need to rewrite your statement with a co-related sub-select
Something like this:
UPDATE system_info
SET field_value = 'NewValue'
WHERE field_desc IN (SELECT role_type
FROM system_users
WHERE user_name = 'uname')
For a complete description on the (valid) syntax of the UPDATE statement, please read the manual:
http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_10008.htm#i2067715