Hi All,
I have following code in DAO layer
Connection conn = factory.createConnection();
String sql = "SELECT group_id FROM " + this.GROUP_TABLE + " WHERE disabled = 'T' AND UPPER(group_name) = ? AND agency_id = ?";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, groupName.trim().toUpperCase());
pstmt.setInt(2, agencyId);
rs = pstmt.executeQuery(sql);
when I execute this code I am getting ORA-03115 error.
If I change sql statement to simple
[HTML]String sql = "SELECT group_id FROM " + this.GROUP_TABLE;[HTML]
it works fine.
I am using
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
"CORE 11.2.0.2.0 Production"
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
Oracle Driver ojdbc6.jar and
jdk1.6.0_24