This week's book giveaway is in the OCMJEA forum.
We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes calling stored procedure with oracle object types as IN and OUT param in ibatis from java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "calling stored procedure with oracle object types as IN and OUT param in ibatis from java" Watch "calling stored procedure with oracle object types as IN and OUT param in ibatis from java" New topic
Author

calling stored procedure with oracle object types as IN and OUT param in ibatis from java

Ratnesh sidhaye
Greenhorn

Joined: Nov 06, 2011
Posts: 2

I want to call stored procedure where IN and OUT parameter are oracle object type and both are different type.
I am using ibatis 2.3 and spring and oracle 11g.
Can someone give me working code or approach to achieve this i tried alot.
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30405
    
150

What did you try last? What error did you get?


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3610
    
  60

This (having a single IN/OUT parameter with different IN and OUT types) is not allowed. There is a workaround described in Oracle's documentation.
 
wood burning stoves
 
subject: calling stored procedure with oracle object types as IN and OUT param in ibatis from java