| Author |
Message
|
| lillo |
 Posted: Sun Aug 04, 2002 11:50 pm Post subject: Stored procedures |
 |
|
Master
Joined: 11 Sep 2001
Posts: 224
|
I am running WMQI 2.1 CSD2 and I want to use a store procedure to retreive a result set from a Oracle. I am also interested in ref cursor type.
Is there any way to do it?
Thanks,
Lillo
_________________
Lillo
IBM Certified Specialist - WebSphere MQ |
|
| Back to top |
|
 |
| sgopal |
| Posted: Fri Aug 09, 2002 9:44 am Post subject: |
|
|
Acolyte
Joined: 30 Jul 2002
Posts: 63
|
Is this still open? You should use PASSTHRU eSQL construct to
invoke stroed procedures.
But there is no cursor support. |
|
| Back to top |
|
|
| gm_naren2001 |
| Posted: Wed Aug 15, 2007 4:51 am Post subject: Re: Stored procedures |
|
|
Newbie
Joined: 27 Apr 2007
Posts: 6
Location: India
|
| lillo wrote: |
I am running WMQI 2.1 CSD2 and I want to use a store procedure to retreive a result set from a Oracle. I am also interested in ref cursor type.
Is there any way to do it?
Thanks,
Lillo |
You better creating your function with stored procedure
_________________
thank you |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Aug 15, 2007 4:52 am Post subject: Re: Stored procedures |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| gm_naren2001 wrote: |
| lillo wrote: |
I am running WMQI 2.1 CSD2 and I want to use a store procedure to retreive a result set from a Oracle. I am also interested in ref cursor type.
Is there any way to do it?
Thanks,
Lillo |
You better creating your function with stored procedure |
Whatever they did, they did it it 5 years ago..... 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Wed Aug 15, 2007 7:08 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
WMQI 2.1 CSD2 its time up to update or upgrade it
You will get lot of functionalities in the new tools
Thanks and Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Aug 15, 2007 7:10 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Please stop posting to a dead thread.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
|
|
