| Author |
Message
|
| ghada |
 Posted: Tue Oct 25, 2005 3:54 am Post subject: handling record set within message flow |
 |
|
Apprentice
Joined: 13 Oct 2005
Posts: 41
Location: Egypt
|
hi all
i'm using WBIMB v5.0 and DBMS Oracle 10g
i'm asked to call a stored procedure that performs a simple select statement and i want to handle the returned record set within the message flow is it possible????
" i used ref_cursor to get the record set out of the procedure"
i appreciate your help
thanks in advance |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Tue Oct 25, 2005 3:56 am Post subject: Re: handling record set within message flow |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| ghada wrote: |
| i'm using WBIMB v5.0 and DBMS Oracle 10g |
This is not a supported DBMS for WBIMB v5.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| ghada |
| Posted: Tue Oct 25, 2005 4:47 am Post subject: |
|
|
Apprentice
Joined: 13 Oct 2005
Posts: 41
Location: Egypt
|
the version is
WBIMB v 5.0.2
with Oracle 10g.0.0.1
=============
i used a direct select statement and it worked????? |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Oct 25, 2005 4:57 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| ghada wrote: |
the version is
WBIMB v 5.0.2
with Oracle 10g.0.0.1 |
Unless they've changed something, Oracle 10g is not supported with WBIMB v5 except on Linux with a specific FP and efix after that.
| ghada wrote: |
=============
i used a direct select statement and it worked????? |
Did you try calling your stored procedure, then? Did it work?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| ghada |
| Posted: Tue Oct 25, 2005 6:10 am Post subject: |
|
|
Apprentice
Joined: 13 Oct 2005
Posts: 41
Location: Egypt
|
yes i did call a stored procedure but it didn't contain a select statement
it only had an insert statement and it worked |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Oct 25, 2005 6:12 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| ghada wrote: |
yes i did call a stored procedure but it didn't contain a select statement
it only had an insert statement and it worked |
Well, try it with a select statement, and see what happens.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| ghada |
| Posted: Tue Oct 25, 2005 6:29 am Post subject: |
|
|
Apprentice
Joined: 13 Oct 2005
Posts: 41
Location: Egypt
|
the problem is not executing the procedure
the problem is how to handle the returned result set from that procedure call |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Oct 25, 2005 6:40 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
And if you execute the stored procedure, you can look at what comes back, to figure out how to handle it.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| ghada |
| Posted: Tue Oct 25, 2005 11:35 pm Post subject: |
|
|
Apprentice
Joined: 13 Oct 2005
Posts: 41
Location: Egypt
|
i changed it to function here is my code
*********************************
CREATE OR REPLACE FUNCTION "API"."GETPARTIES" return SYS_REFCURSOR
is MyCursor SYS_REFCURSOR;
begin
open MyCursor for select * from API.PORT_PARTIES;
return ( MyCursor);
end;
********************************
Then when i call it:
********************************
VAR X REFCURSOR ;
VAR ID VARCHAR2(5);
VAR NAME VARCHAR2(40);
VAR QM VARCHAR2(10);
exec :X := API.GETPARTIES();
print X;
*******************************
this works on Oracle, how can i handle the returned Ref_cursor "X" in message flow?????? |
|
| Back to top |
|
|
| JT |
| Posted: Wed Oct 26, 2005 5:33 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
|
| Back to top |
|
|
| ghada |
| Posted: Mon Nov 07, 2005 3:40 am Post subject: |
|
|
Apprentice
Joined: 13 Oct 2005
Posts: 41
Location: Egypt
|
hi all
i found new information about my problem, i thoght it will be helpfull to share that with others, here it is:
Customers environment is : WBIMB v5 FP6 on Windows with Oracle 10g
- WBIMB v5 FP6 does not support Oracle 10g
- The exception to this is WBIMB v5 FP04+ on Linux with fix LCR016
- WBIMB v5 support for Oracle 10g is currently undergoing lifecycle
testing
- If/When this testing is completed then support for Oracle 10g would
be announced (via a FP release)
thanks all |
|
| Back to top |
|
|
| EddieA |
| Posted: Mon Nov 07, 2005 9:25 am Post subject: |
|
|
Jedi
Joined: 28 Jun 2001
Posts: 2453
Location: Los Angeles
|
Isn't that exactly what Jeff told you earlier:
| jefflowrey wrote: |
Unless they've changed something, Oracle 10g is not supported with WBIMB v5 except on Linux with a specific FP and efix after that. |
Cheers,
_________________
Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
| Back to top |
|
|
|
|
