| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Call Oracle stored procedure |
« View previous topic :: View next topic » |
| Author |
Message
|
| 4integration |
 Posted: Wed Sep 12, 2007 2:57 am Post subject: Call Oracle stored procedure |
 |
|
Disciple
Joined: 04 Sep 2006
Posts: 197
Location: Gothenburg, Sweden
|
Hello,
I have a problem of calling a Oracle stored procedure. Probably it's a very simple solution on it but the documentation is not that good (I think). Therefore I would be very happy if someone could throw some light on it.
The SP looks like:
| Code: |
CREATE OR REPLACE PROCEDURE VRH.PROC_VOSP_QRY_GDS_REPAIR (
p_TCHASSIS IN varchar2,
p_REPAIRDATE IN varchar2,
ResultSet1 OUT SYS_REFCURSOR) AS
BEGIN
IF ResultSet1%ISOPEN THEN
CLOSE ResultSet1;
END IF;
OPEN ResultSet1 FOR
SELECT
TCHASSIS AS CHASSIS_ID,
MILEAGE,
REPAIRDATE AS SERVICE_DATE,
CODE AS OPERATION_TYPE
FROM
vw_VOSP_qry_GDS_repair
WHERE
tchassis = p_tchassis
and REPAIRDATE >= to_date(p_repairdate, 'YYYYMMDD')
order by repairdate asc;
END PROC_VOSP_QRY_GDS_REPAIR;
/ |
The Business object(s) are looking as:
| Code: |
PROC_VOSP_QRY_GDS_REPAIR_WRAPPER (WRAPPER=TRUE)
P_TCHASSIS (string, PK)
boList (Type: PROC_VOSP_QRY_GDS_REPAIR, Cardinality: N)
P_TCHASSIS (string, PK/FK), ASI: CN=P_TCHASSIS:FK=PROC_VOSP_QRY_GDS_REPAIR_WRAPPER.P_TCHASSIS
P_REPAIRDATE (string), ASI: CN=P_REPAIRDATE
RetrieveSP (Type: GDS_REPAIR, Cardinality: N), ASI: SPN=PROC_VOSP_QRY_GDS_REPAIR;RS=true;IP=P_TCHASSIS:P_REPAIRDATE;OP=RS
CHASSIS_ID (string, PK), ASI: CN=CHASSIS_ID
MILEAGE (string), ASI: CN=MILEAGE
SERVICE_DATE (string), ASI: CN=SERVICE_DATE
OPERATION_TYPE (string), ASI: CN=OPERATION_TYPE
|
When executing I get:
| Code: |
[Time: 2007/09/12 12:17:21.579] [System: ConnectorAgent] [SS: JDBC_TSRConnector] [Thread: WBIA.JDBC_TSR.REQUESTQUEUEJmsThreadPool.thread1 (#1563738466)] [Type: Error] [MsgID: 10556] [Mesg: Exception Detail: com.crossworlds.cwconnectorapi.exceptions.VerbProcessingFailedException
[Type: Error] [MsgID: 34019] [Mesg: Wrong attribute found at index 2 for object PROC_VOSP_QRY_GDS_REPAIR.] ]
[Time: 2007/09/12 12:17:21.579] [System: ConnectorAgent] [SS: JDBC_TSRConnector] [Thread: WBIA.JDBC_TSR.REQUESTQUEUEJmsThreadPool.thread1 (#1563738466)] [Type: Trace] [Mesg: :
com.crossworlds.cwconnectorapi.exceptions.VerbProcessingFailedException: [Type: Error] [MsgID: 34019] [Mesg: Wrong attribute found at index 2 for object PROC_VOSP_QRY_GDS_REPAIR.]
at com.crossworlds.connectors.JDBC.JDBCBOhandler.doVerbFor(JDBCBOhandler.java:332)
at com.crossworlds.cwconnectorapi.CWConnectorBOHandler.doVerbFor(CWConnectorBOHandler.java:127)
at CxCommon.BusinessObject.doVerbFor(BusinessObject.java:2179)
at AppSide_Connector.BusObjJavaInterface.DoVerbFor(BusObjJavaInterface.java:255)
at AppSide_Connector.AppCalls.DoVerbFor(AppCalls.java:266)
at AppSide_Connector.AgentBusinessObjectManager.DoVerbFor(AgentBusinessObjectManager.java:1777)
at CxCommon.Messaging.ClientPacketSyncDrvFormatter.receiverCallback(ClientPacketSyncDrvFormatter.java:1543)
at CxCommon.Messaging.jms.Receiver.processBO(Receiver.java:876)
at CxCommon.Messaging.jms.Receiver.processMsg(Receiver.java:467)
]
|
_________________
Best regards
4 Integration |
|
| Back to top |
|
 |
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
