10 Jun 2010 18:49
Need help on calling stored procedure from ibatis
prabu p <prabugct <at> gmail.com>
2010-06-10 16:49:03 GMT
2010-06-10 16:49:03 GMT
As I am new to ibatis, I need your help on calling stored
procedure from ibatis.
Here is the code I am trying to call stored procedure, but it is not
working.
Stored procedure as follows:-
getRadiusData( rc OUT SYS_REFCURSOR,ArgFromDate in varchar2,ArgEndDate in
varchar2,
rptType VARCHAR2,timeRange VARCHAR2, authStatus VARCHAR2,userName
VARCHAR2,identityGroup VARCHAR2 ,
netwokDeviceGroup VARCHAR2 ,netwokDevicename VARCHAR2 ,accessService
VARCHAR2 ,identityStore VARCHAR2 ,
acsInstance VARCHAR2,Failure_Reason VARCHAR2,Calling_Station_ID
VARCHAR2,Device_IP_Address VARCHAR2,
Audit_Session_ID VARCHAR2,ACS_Session_ID VARCHAR2, Acct_Session_ID
VARCHAR2,isMab VARCHAR2,adDomain VARCHAR2,
CTS_Security_Group VARCHAR2, Show_SGT_Assign VARCHAR2, Show_SGT_Environment
VARCHAR2,ID number ,
isDrillDown number)
XDEQueriesMap.xml file has entry as follows:-
<procedure id="getRadiusData" parameterClass="java.util.HashMap"
resultClass="java.util.HashMap">
{call getRadiusData(?, #FromDate#, #ToDate#,
#AuthenticationStatus#, #TimeRange#, 'All', #UserName#, 'All', 'All', 'All',
'All', 'All', 'All', #FailureReason#,
(Continue reading)
RSS Feed