Subject | Subscribing Events |
---|---|
Author | Mahesh Ishwar |
Post date | 2003-09-15T08:05:59Z |
Hello All,
I can publish an event by writing POST_EVENT(<event_name>) in a stored procedure or in a trigger. Can someone tell me how to become a subscriber of this event in another stored procedure?
What I want is whenever my 'publisher' stored procedure is called, all the 'subscriber' stored procedures should also be executed.
In the '60EmbedSql.pdf', they have given some syntax, but it is for embedded sql and the syntax(i.e., EVENT INIT, etc.) doesn't even lets to compile the stored procedure.
Thanx in advance.
Mahesh.
---------------------------------
Want to chat instantly with your online friends? Get the FREE Yahoo!Messenger
[Non-text portions of this message have been removed]
I can publish an event by writing POST_EVENT(<event_name>) in a stored procedure or in a trigger. Can someone tell me how to become a subscriber of this event in another stored procedure?
What I want is whenever my 'publisher' stored procedure is called, all the 'subscriber' stored procedures should also be executed.
In the '60EmbedSql.pdf', they have given some syntax, but it is for embedded sql and the syntax(i.e., EVENT INIT, etc.) doesn't even lets to compile the stored procedure.
Thanx in advance.
Mahesh.
---------------------------------
Want to chat instantly with your online friends? Get the FREE Yahoo!Messenger
[Non-text portions of this message have been removed]