wood burning stoves 2.0*
The moose likes JDBC and the fly likes JDBC call to PLSQL block having Oracle type object parameter Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC call to PLSQL block having Oracle type object parameter" Watch "JDBC call to PLSQL block having Oracle type object parameter" New topic
Author

JDBC call to PLSQL block having Oracle type object parameter

Rohit Loke
Greenhorn

Joined: Nov 21, 2006
Posts: 6
Hi Guys,

I have been atempting migration from Oracle 9i to 10g(both app server and DB) for my application and am stuck on two issues related to Oracle TYPE parameters.

1. When the "Type" parameter in IN/OUT we get the "protocol violation" error, and if we change the parameter to just IN
it completes the JDBC call successfully without error.
2. Irrespective of the TYPE paramter being just IN or IN/OUT some values seem to be lost when call is made.

The code snippet below replicates what is happening in my applcation and output printed in the end, any suggestions are highly appreciated.

Thanks
-Rohit

These are the environment details

App server version : Oracle Application Server 10g 10.1.2.0.2
Database version : Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit
JDBC ver. :10.1.0.5.0


 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC call to PLSQL block having Oracle type object parameter
 
Similar Threads
XML Parsing issue.
Problem in file transfer
Can anyone explain what is == and equal( ) ?
String ==
equals versus ==