This week's book giveaway is in the OCAJP 8 forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori 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 OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 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
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 32636
    
216

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


[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3719
    
  61

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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: calling stored procedure with oracle object types as IN and OUT param in ibatis from java
 
It's not a secret anymore!