JDBC Adapter Stored Procedure Call

jayaprakash · November 30, 2007, 4:34pm

Hi Administrator,

Can you pls let me know how to call an Oracle stored procedure in webMethods? Pls provide with example if it is possible.

Regards,
Prakash

reamon · November 30, 2007, 8:52pm

Please review the JDBC Adapter User’s Guide. It describes how to call stored procedures.

jayaprakash · November 30, 2007, 9:28pm

Where I can find the document? I dont find at webMethods\Developer\doc\guides

Regards,
Jayapraksh.T

wMusers.Com1 · November 30, 2007, 9:32pm

wm_home\Packages\WmJDBCAdapter\docs

jayaprakash · November 30, 2007, 9:35pm

Thanks!

Regards,
Jayaprakash.T

Alekhya_Bezawada · January 7, 2013, 5:38pm

[FONT=PalatinoLinotype-Roman][SIZE=2]I was created stored procedure Notification , but while time it is retrieving all the records but i need new updated records, To ensure that the same data is not published multiple times, design and test your stored procedure so that whenever the stored procedure is invoked , do we need any settings?

where i need to set the outout record structure?[/SIZE][/FONT]

Alekhya_Bezawada · January 8, 2013, 9:54am

some one suggest me in this issue?

reamon · January 8, 2013, 1:26pm

Your stored procedure needs to determine what records are considered updated and which are not. Perhaps it could update the records it processes with a flag of some sort.