Not all variables bound
Hi, I'm new to Oracle DB and I try to use bind variables where ever possible. The following is what I try to execute from JDBC:
var sql = select u.username, u.password, u.account_status, u.default_tablespace, u.temporary_tablespace, u.profile, u.external_name , a.last_access_date from dba_users u , (SELECT to_char(MAX(b.TIMESTAMP), 'YYYYMMDDHH24MI') last_access_date, b.username FROM dba_audit_session b GROUP BY b.username) a WHERE u.username = a.username(+) AND u.USERNAME LIKE ? group by u.username, u.password, u.account_status, u.default_tablespace, u.temporary_tablespace, u.profile,u.external_name, a.last_access_date
var sql = select u.username, u.password, u.account_status, u.default_tablespace, u.temporary_tablespace, u.profile, u.external_name , a.last_access_date from dba_users u , (SELECT to_char(MAX(b.TIMESTAMP), 'YYYYMMDDHH24MI') last_access_date, b.username FROM dba_audit_session b GROUP BY b.username) a WHERE u.username = a.username(+) AND u.USERNAME LIKE ? group by u.username, u.password, u.account_status, u.default_tablespace, u.temporary_tablespace, u.profile,u.external_name, a.last_access_date
0