| Author |
Message |
 Topic: Help Calling Oracle stored procedure ref cursor in esql |
karthusb
Replies: 22
Views: 18313
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jul 08, 2013 7:40 am Subject: Help Calling Oracle stored procedure ref cursor in esql |
| Thanks for the quick reply . I will give a try |
| Topic: Help Calling Oracle stored procedure ref cursor in esql |
karthusb
Replies: 22
Views: 18313
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jul 08, 2013 6:26 am Subject: Help Calling Oracle stored procedure ref cursor in esql |
I am sorry , I tried with your sugeestion stil no success.
from the below error messge its clearly seen that error occured in ESQL Procedure .
I am not sure what combination i need to add to it..
... |
| Topic: Help Calling Oracle stored procedure ref cursor in esql |
karthusb
Replies: 22
Views: 18313
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jul 08, 2013 5:21 am Subject: Help Calling Oracle stored procedure ref cursor in esql |
Hi Can you please reply to where my code is wrong , so that i can give a try.
Thanks,
Sri |
| Topic: Help Calling Oracle stored procedure ref cursor in esql |
karthusb
Replies: 22
Views: 18313
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jul 04, 2013 3:04 pm Subject: Help Calling Oracle stored procedure ref cursor in esql |
Yes the statement you have said is true .
The DB procedure returns 1 result set and 2 out parameters considered to be totally 3 out parameters .
following are the ways i have tried to retrieve det ... |
| Topic: Help Calling Oracle stored procedure ref cursor in esql |
karthusb
Replies: 22
Views: 18313
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jul 03, 2013 11:31 am Subject: Help Calling Oracle stored procedure ref cursor in esql |
| thats the first piece of code i posted when asking for help. It did not work |
| Topic: Help Calling Oracle stored procedure ref cursor in esql |
karthusb
Replies: 22
Views: 18313
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jul 03, 2013 9:57 am Subject: Help Calling Oracle stored procedure ref cursor in esql |
Yes I did try with float , decimal Datatype earlier ..
I definetly think there is no issue with SP as its working good with PASSTHRU statement .
PROCEDURE get_site_info
(
p_ev_idn IN e ... |
| Topic: Help Calling Oracle stored procedure ref cursor in esql |
karthusb
Replies: 22
Views: 18313
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jul 03, 2013 9:38 am Subject: Help Calling Oracle stored procedure ref cursor in esql |
Thank you for your suggestion ,
I even tried that earlier but no luck . But upon your suggestion I gave a shot once again but same error prevails. |
| Topic: Help Calling Oracle stored procedure ref cursor in esql |
karthusb
Replies: 22
Views: 18313
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jul 03, 2013 8:07 am Subject: Help Calling Oracle stored procedure ref cursor in esql |
I tried all the combinations before posting .. but no luck ..
CREATE PROCEDURE GET_SITE_INFO(IN P_EV_IDN INTEGER ,IN P_OLD_METER_NUMBER CHARACTER , OUT P_SITE_INFO CHARACTER , OUT P_SUCCESS_FLAG ... |
| Topic: Help Calling Oracle stored procedure ref cursor in esql |
karthusb
Replies: 22
Views: 18313
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jul 03, 2013 5:27 am Subject: Help Calling Oracle stored procedure ref cursor in esql |
P_EV_IDN = NUMBER(9,0) in SP
p_OLD_METER_NUMBER = VARCHAR2(25 bytes) in SP
Out of 3 dynamic results only one returns list which is the cursor referense in SP .
other 2 returns character values.
... |
| Topic: Help Calling Oracle stored procedure ref cursor in esql |
karthusb
Replies: 22
Views: 18313
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jul 02, 2013 11:50 am Subject: Help Calling Oracle stored procedure ref cursor in esql |
Previous answeres doesn't clearly have any resolution steps ..-(
Anyway , If the Connections are wrong I should not get PASSTHRU statement work .
Its not connection problem Its calling statement ... |
| Topic: Help Calling Oracle stored procedure ref cursor in esql |
karthusb
Replies: 22
Views: 18313
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jul 02, 2013 9:45 am Subject: Still no Success |
Hello Thanks for your response ,
Passthrough statement works but returns only one result set .
SET Environment.Variable.output[] = PASSTHRU('{CALL csb.csbkd400.get_site_info(?,?,?,?,?)}' values ... |
| Topic: Help Calling Oracle stored procedure ref cursor in esql |
karthusb
Replies: 22
Views: 18313
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jun 27, 2013 1:02 pm Subject: Help Calling Oracle stored procedure ref cursor in esql |
Hello All ,
I am trying to call oracle stored procedure which has reference cursor, I tried muliple way but getting following error
The procedure '&1' with '&2' parameters could not be m ... |
