calling PL/SQL block from Notification.

Hi All,

The situation I have is – when the Notificaiton is triggered, it will call a PL/SQL code block and hand over an Employee ID.
PL/SQL will pull bunch of records from the database and will return it back, which will be handed over to the publishing service on webMethods.

How to handle this? How to pass a parameter to PL/SQL Block from Notification?

Please Help…


Can you pass the parameter from subscribe service that gets triggered by the notification?

Are you using JDBC Adapter select or custom template for PL/SQL query?