Oracle error List and solutions

This post includes the Oracle errors i got during my development (java code, Stored Procedure, executing SQL from TOAD/SQLPlus). I tried to give little history for each error to understand the problem I had.

---

Error:
ORA-01460: unimplemented or unreasonable conversion requested

History:
Environment- Red Hat LInux 4.5/JBoss 4.0.5 GA/Oracle 10g (OS/Application server/database)
I was using ojdbc14.jar for Oracle9i driver and when i try to save a file as BLOB in oracle database from my java code (using JNDI), this exception was thrown.

Solution:
Use ojdbc14.jar of version 10.2.0.4.

Error:
ORA-17009: Closed Statement : Next

History:
In DB Accessor class, first method calls second method which returns a ResultSet and the second method is actually creates DB connection, statement and executes the query. The second method closes the connection and statement in finally block. So, when first method try to traverse the ResultSet

Solution:
Use ojdbc14.jar of version 10.2.0.4.

How to avoid confirmation message when closing browser using window.close()

Description:
From javascript, when we use window.close() to close the browser window programmatically, Internet explorer shows a confirmation message.

Solution:
This solution does work for both IE 6 & 7.

Code snippet-start
Part 1:
function closeWindow(){
window.opener = ''; //Line 1
window.open('', '_self',''); // Line 2
window.close();
}

Part 2:
input value="Close Browser" onclick="closeWindow()" type="button"

Code snippet-end

Explanation:
Line 1 - is required for IE 6
Line 2 - is required for IE 7