> > Exactly what semantics do you have in mind?
>
> The current syntax I'm using is:
>
> NOTIFY condition_name [ [WITH MESSAGE] 'my message' ];
>
> But I'm open to suggestions for improvement.
Have you considered visiting the oracle site and finding their documentation
for their NOTIFY statement and making sure you're using compatible syntax?
They might have extra stuff as well.
Chris