A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Refactoring for Software Design Smells: Managing Technical Debt
this week in the
OO, Patterns, UML and Refactoring
calling stored procedure with oracle object types as IN and OUT param in ibatis from java
Joined: Nov 06, 2011
May 29, 2012 02:29:50
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
author & internet detective
Joined: May 26, 2003
May 29, 2012 19:58:13
What did you try last? What error did you get?
OCA 8 book
How To Ask Questions The Smart Way
SCEA Part 1
Part 2 & 3
Core Spring 3
TOGAF part 1
Joined: Aug 22, 2010
May 30, 2012 01:10:52
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’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: calling stored procedure with oracle object types as IN and OUT param in ibatis from java
Need help in iBatis !
Varchar & Varchar2 in Stored procedure
Is it a good design model (struts + hibernate)?
Adv JDBC ?
iBatis | Function Call as a Paramter to Procedure Call?
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015