JDBC Adapter Stored Procedure Call

, ,
1

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

2

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

3

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

Regards,
Jayapraksh.T

4

wm_home\Packages\WmJDBCAdapter\docs

5

Thanks!

Regards,
Jayaprakash.T

6

[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]

7

some one suggest me in this issue?

8

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.