Hi all, I am using Oracle 8.1.6 with Oracle ODBC driver 8.1.6.I have union query which works fine when i execute in SQL Plus editor.The same query if i execute in JSP gives me different result.I am getting duplicate values if i execute in JSP whereas in sql plus it is not giving me duplicate values. Help me please...
The only thing I can think of is that they may be happening inside different transaction contexts (try doing a commit in the SQLPLUS window before running the query), but you'd have to tell us more about what is happening or show us some SQL... Dave
Joined: Aug 29, 2003
Hi, It was working fine know.I dont know why it didnt worked that time.I didnt change the code also.