| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Calling a Oracle function from ESQL |
« View previous topic :: View next topic » |
| Author |
Message
|
| md.sadruddin |
 Posted: Wed Mar 24, 2010 7:18 am Post subject: Calling a Oracle function from ESQL |
 |
|
Novice
Joined: 27 Aug 2009
Posts: 12
|
Hi,
Can we call a oracle function (not Stored Procedure) from ESQL?
If so, could people give me some hints?
(I am using WMB 6.1)
Thanks very much in advance.
regards,
salman |
|
| Back to top |
|
 |
| Vitor |
| Posted: Wed Mar 24, 2010 7:28 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
What function does Oracle have that ESQL does not that you need to call?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Wed Mar 24, 2010 7:49 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
| Vitor wrote: |
| What function does Oracle have that ESQL does not that you need to call? |
LOL 
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| mgk |
| Posted: Wed Mar 24, 2010 7:51 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
From an ESQL point of view, Oracle Stored Functions are the same as Stored Procedures, except they return a value. As long as the data types the procedure takes are supported (same at stored procedures) you simply define it the same as you would a Procedure, but with the addition of a RETURNS clause..
Kind Regards,
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
| md.sadruddin |
| Posted: Wed Mar 24, 2010 10:27 am Post subject: |
|
|
Novice
Joined: 27 Aug 2009
Posts: 12
|
|
| 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
|
|
|
|
