Tag Archives: oracle

Call Oracle PL/SQL procedure with XMLType from Java using JDBC

Posted on March 11, 2011 by

Recently I needed to call a stored procedure which had Oracle’s XMLType as IN and OUT parameters. The first thing to do is add xdb.jar and xmlparserv2.jar file to your application lib. These contain the required class files for Oracle … Continue reading →

Posted in Database, Integration, Java, Oracle | Tagged , , , , , | 1 Comment

Database Diff / Database Change Management

Posted on August 17, 2010 by

Recently we had a situation when two developers were working on same DB package. Delay in submission of deployment request by one dev resulted in package compilation error as a dependent Type was missing. I was looking for solution that … Continue reading →

Posted in Database | Tagged , | Leave a comment