|JServer - Java In The Database - The first steps along the route to placing java code in an Oracle 8i database.|
Ben Thoma said...Another good page to find out about stored procedures is Oracle's page: http://www.oracle.com/technology/sample_code/tech/java/jsp/oracle9ijsp.html
That, and to get a better understanding of IN/OUT/INOUT procedures, do a quick read at:
Ben Thoma said...By the way, this page is very helpful.
Arindam Mukherjee said...In Oracle 10g, connection and type casting of the existing program can be written in easy format like below.
// Connect to the database
Connection conn = DriverManager.getConnection("jdbc:default:connection:");
iReturn = resultSet.getInt(1);
I am sorry, I did not try the above snippet in Oracle 8i
Your quite correct. I checked the Java 1.2 ResultSet class and it did support the getInt method. It just goes to show how little I knew about Java then. :)
Thanks for the heads-up.