| Author |
Message
|
| Anghel |
 Posted: Mon Jun 22, 2009 1:27 am Post subject: How to call oracle stored funcion from ESQL,pls help me |
 |
|
Newbie
Joined: 22 Jun 2009
Posts: 3
|
Hello,
How to call oracle stored funcion from ESQL?
Thanks |
|
| Back to top |
|
 |
| WMBDEV1 |
| Posted: Mon Jun 22, 2009 1:55 am Post subject: |
|
|
Sentinel
Joined: 05 Mar 2009
Posts: 888
Location: UK
|
|
| Back to top |
|
|
| Anghel |
| Posted: Mon Jun 22, 2009 2:04 am Post subject: |
|
|
Newbie
Joined: 22 Jun 2009
Posts: 3
|
| I don't need to call stored procedure, I need to call stored function |
|
| Back to top |
|
|
| mgk |
| Posted: Mon Jun 22, 2009 2:14 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1647
|
WMB treats Oracle Stored Functions and Stored Procedures as the same thing. The only difference is that Functions have a return value.
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 |
|
|
| Anghel |
| Posted: Mon Jun 22, 2009 2:30 am Post subject: |
|
|
Newbie
Joined: 22 Jun 2009
Posts: 3
|
From ESQL I can't create function with language database, only procedure. But when define procedure I can't returns value from function.
Give me pls example |
|
| Back to top |
|
|
| WMBDEV1 |
| Posted: Mon Jun 22, 2009 2:41 am Post subject: |
|
|
Sentinel
Joined: 05 Mar 2009
Posts: 888
Location: UK
|
Did you read the link I sent you? did it not help?
I can give no better advice than that. |
|
| Back to top |
|
|
| mgk |
| Posted: Mon Jun 22, 2009 3:25 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1647
|
I tried to explain above. ESQL Procedures with LANGUAGE DATABASE can be used to CALL Oracle Stored Functions as ESQL Procedures CAN have RETURN values. Use the link above to the docs and try it and you will see it works!
_________________
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 |
|
|
|
|
