File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Ratnesh sidhaye
Greenhorn
Posts: 2
Hibernate MyEclipse IDE Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 33691
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What did you try last? What error did you get?
 
Martin Vajsar
Sheriff
Pie
Posts: 3747
62
Chrome Netbeans IDE Oracle
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic