Stored Procedures

[Former Member]

Hi friends

Iam working on JDBC Sender. I want to execute a stored procedure through XI that will retrive me all the records that are present in a specified table. How can I do that? If anyone have worked on this before please tell me the way to create a procedure in Oracle Sql plus and exec it in XI.

Thanks in Advance....

[Former Member · Accepted solution]

HI

Go thru this blog it will help u to understand how Stored Procedure can be used in XI

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

Regards

Arpit Seth

[Former Member]

Hi,

To retrieve all records from a table, you can use simple select statement without stored procedure.

To create stored procedure, refer the following link.This may help u.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_07_7yw5.asp

Regards,

Uma

[Former Member]

I believe you have to configure a RECIEVER JDBC adapter to execute a stored proc , chk the statement 5 in this link which gives an idea of the JDBC data strcuture to be created in repository.

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

Thanks

Saravana

[Former Member]

XI's jdbc sender adapter requires a stored procedure to return a resultset, which Oracle's stored procedure cannot do.

An adapter user-module is available to get around this limitation.

I can send it to you if still need it.

Regards

[Former Member]

Hi Narayana

"tell me the way to create a procedure in Oracle Sql plus "

The following link explains how to write Stored procedure in Oracle SqlPlus

http://www.enterprisedt.com/publications/oracle/result_set.html

"how to exec stored procedure it in XI using sender JDBC"

http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

cheers

Sameer