Skip to Content
0
Former Member
Dec 02, 2009 at 09:41 AM

Problem with Stored Procedure exection in Sender and Receiver side of JDBC

38 Views

Hi All,

I am facing problem while executing Stored Procedures using sender and receiver sides of JDBC adapter.

Here is my SP in Oracle DB :

PROCEDURE EMP

( ID IN VARCHAR2,NAME IN VARCHAR2,PROCESSED IN VARCHAR2 ) AS

BEGIN

INSERT INTO EMPLOYEE VALUES (ID, NAME, PROCESSED);COMMIT;END EMP;

Now I want to execute this SP using sender JDBC channel and receiver JDBC channel.

Can anyone please help me executing this SP?

Regards,

Soorya