aspose file tools*
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 Java 8 in Action this week in the Java 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
internet detective
Marshal

Joined: May 26, 2003
Posts: 29287
    
140

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: 3454
    
  47

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
 
Similar Threads
Need help in iBatis !
Adv JDBC ?
Is it a good design model (struts + hibernate)?
Varchar & Varchar2 in Stored procedure
iBatis | Function Call as a Paramter to Procedure Call?