| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| How to call the DB function from ESQL? |
« View previous topic :: View next topic » |
| Author |
Message
|
| gheekshike |
 Posted: Sun Apr 13, 2014 2:22 am Post subject: How to call the DB function from ESQL? |
 |
|
Novice
Joined: 13 Dec 2012
Posts: 11
|
Hi all,
I have Oracle db Function like this
| Code: |
FUNCTION GET_UNBILED_TRANSACTION ( p_card_number IN VARCHAR2,
p_transaction_list OUT CLOB,
p_error_code OUT VARCHAR2,
p_error_description OUT VARCHAR2)
RETURN PLS_INTEGER;"
|
How can I call the above function from ESQL?
Please help me, Its urgent
Thanks In Advance.
 |
|
| Back to top |
|
 |
| kimbert |
| Posted: Mon Apr 14, 2014 1:20 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
We will be glad to help, but there is a *lot* of information on the internet.
We do not want to tell you things that you already know. So please tell us:
a) where you have looked for information and
b) what you have tried ( and what happened when you tried it ).
_________________
Before you criticize someone, walk a mile in their shoes. That way you're a mile away, and you have their shoes too. |
|
| Back to top |
|
|
| mqsiuser |
| Posted: Mon Apr 14, 2014 2:26 am Post subject: Re: How to call the DB function from ESQL? |
|
|
Yatiri
Joined: 15 Apr 2008
Posts: 637
Location: Germany
|
If you have something working on your Oracle(-SQL-Developer) you can just copy and paste that and put it into a "PASSTHRU("...")" in ESQL
(I am not sure if this works with stored procedures, but with SQL-Queries it does!)
You have to configure ODBC data sources (for the connection with Oracle), which is properly documented in the forum.
_________________
Just use REFERENCEs |
|
| 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
|
|
|
|
