Does XI support PLSQL Functions?

[Former Member]

Hi...

Generally we use Stored Procedure at the Receiver end with JDBC Adapter. I wanted to know if XI supports PLSQL Function?

If so, can anyone please tell me the structure to be used. Is it the same one as for Procedure??

[Former Member]

Thanks for ur reply... can u please tell me what should be the version of XI and Oracle database so that PLSQL Functions may be called from XI.

I got to know that Oracle version should be >=10g and XI Service Pack>=14.

Can anyone send me a blog confirming the version?

[Former Member]

Hi Jayalaxmi,

i dont think any version will differ in updating database tables.we can update any version.iam also working in IDOC to JDBC senario and we are not worried about verion.we have to check is it DB tables or SQL tables and about JDBC connection parameters.

regards,

phani

[former_member189387]

Hi ,

Plse go througnthe following links

Here is an example of mapping for synch JDBC.

/people/siva.maranani/blog/2005/09/16/xi-how-to-on-jdbc-receiver-response

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

Also go thru these links:

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

/people/alessandro.berta/blog/2005/10/04/save-time-with-generalized-jdbc-datatypes

http://help.sap.com/saphelp_nw2004s/helpdata/en/4d/8c103e05df2e4b95cbcc68fed61705/frameset.htm

• Assign points if you found helpful

Regards.,

V.Rangarajan