WEB SERVICE TO ORACLE SCENARIO

[Former Member]

Hi all,

I have to develop a web services to Oracle scenario. My problem is that I need to executed selects and stored procedure at runtime in the mapping. I mean that i need to check some values from the inbound during the mapping execution I did that before in Sap R/3 but i don´t know how to execute it in a Database.

Many thanks for your help!!!

Regards

Noelia

[MichalKrawczyk]

hi,

you can use standard API to do this lookup in

the mappings:

/people/siva.maranani/blog/2005/08/23/lookup146s-in-xi-made-simpler

Regards,

michal

-

---

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

[Shabarish_Nair]

Stored Procedure - /people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

have a look !!!

[Former Member]

Hi ,

Check this blog..

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

Sekhar