Call Oracle Function via JDBC Adapter

[Former Member]

Hi to everybody,

using JDBC connection with an Oracle DB, from XI I manage to send messages to execute SQL statements or Stored Procedures. Does anybody know if there is a way to call also an Oracle Function?

Thanks a lot for any help...

Ilaria

[bhavesh_kantilal]

Hi Illaria,

I think i agree with Michal. The solution to your problem would be to go for a stored procedure. The link on SDN help only tells us that a stored procedure can be executed and does not discuss about oracle functions.

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

So, Stored Procedures, it has to be.

Regards,

Bhavesh

[MichalKrawczyk]

Hi Ilaria,

can you execute an oracle's function from a stored procedure?

Regards,

michal

-

---

<a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions">XI FAQ - Frequently Asked Questions</a>

[Former Member]

Hi Michal,

I think this may be a solution. But I can't develop on Oracle environment cause it has owned by the customer... So I have to tell the customer from XI it is not possible to call oracle functions and he has to develop a stored procedure for our purpose.

I want to be sure about that...