This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes JDBC and the fly likes calling stored procedure with multiple IN/OUT parameters Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "calling stored procedure with multiple IN/OUT parameters" Watch "calling stored procedure with multiple IN/OUT parameters" New topic
Author

calling stored procedure with multiple IN/OUT parameters

jazy smith
Ranch Hand

Joined: Nov 18, 2009
Posts: 101
Hi all,

I have the store procedure as described below with four input fields and few output fields. I want to call this procedure from the method : dueDate(Request reqObj) { ... }
I want to log the data that is there in reqObj. the input filed described in stored procedure are defined in the Request class. How would be the syntax of the piece of code to call this stored procedure and log the input as well as output fields.




PROCEDURE vrP_GetOrderDetailsByMON
(
i_MASTERORDERNUM IN SERVICEORDER.MASTERORDERNUM%TYPE,
i_SERVICEORDERNUM IN SERVICEORDER.SERVICEORDERNUM%TYPE,
i_SERVICEORDERTYPE IN SERVICEORDER.SERVICEORDERTYPE%TYPE,
i_STATECODE IN SERVICEORDER.STATECODE%TYPE,


o_WIRECENTERID OUT SERVICEORDER.WIRECENTERID%TYPE,
o_CLASSOFSERVICENAME OUT SERVICEORDER.CLASSOFSERVICENAME%TYPE,
o_HSIIND OUT SERVICEORDERRESERVATION.UNITYIND%TYPE,
o_MCN OUT SERVICEORDER.MCN%TYPE,
o_SERVICECODEMODIFIER OUT SERVICEORDER.SERVICECODEMODIFIER%TYPE,
o_SERVICEADDRESS OUT SERVICEORDER.SERVICEADDRESS%TYPE,
o_EASTORDERDETAILSFLAG OUT CHAR,
o_WESTORDERDETAILSFLAG OUT CHAR,

--FTTPDETAILS--------
o_FTTPONTREQUIREDIND OUT SERVICEORDER.FTTPONTREQUIREDIND%TYPE,
o_FTTPENGINEERINGINTERVAL OUT SERVICEORDER.FTTPENGINEERINGINTERVAL%TYPE,
o_FTTPDROPTYPE OUT SERVICEORDER.FTTPDROPTYPE%TYPE,
o_FTTPONTTYPE OUT SERVICEORDER.FTTPONTTYPE%TYPE,
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: calling stored procedure with multiple IN/OUT parameters