insert into emp(name) values('test') <--- Works in SQL Plus
insert into emp values('test2') <--- Works in SQL Plus
insert into emp values(test2) <--- "ORA-00984: column not allowed here" in SQL Plus

package jagranerp.myapplication;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import android.util.Log;

public class TestOracleJDBC {
    private Connection conn;
    private Statement stmt;
    public TestOracleJDBC() throws ClassNotFoundException {
        try {

            Class.forName("oracle.jdbc.driver.OracleDriver");
            String url = "jdbc:oracle:thin:@192.168.1.111:1521/db1";
            this.conn = DriverManager.getConnection(url,"utk","utkarsh");
            this.conn.setAutoCommit(false);
            this.stmt = this.conn.createStatement();

        } catch(SQLException e) {
            Log.d("tag", e.getMessage());
        }
    }


    public ResultSet getResult() throws SQLException {
        String s="insert into emp values ('test')";
        ResultSet res=stmt.executeQuery(s);

        while(res.next()){
            System.out.println(res.getString(1));
        }return  null;
    }
}