This discussion is archived
0 Replies Latest reply: Sep 27, 2006 12:24 PM by Wendy Tromp RSS

server side rule and procCall -> only in es_mail schema

Wendy Tromp Newbie
Currently Being Moderated
I am trying to call procedures in the procCall tag of a server side rule, but I cannot make it work for procedures that are not in the es_mail schema.
I tried creating synonyms and I am dead sure my grants are correct, but as soon as I add a schema name in front of the call it stops working.

Is this correct, people of Oracle, and why?

Wendy