Calling a stored procedure from a trigger

[mghafoori]

I need to call a stored procedure from inside a trigger. I am sure that it is just then name of the procedure, but when i try to compile the trigger i get an error that it doesn't recognize the name. any thoughts?

 

[Dagon]

Are you calling a packaged procedure ? If so, you need to prefix the name of the procedure with the name of the package. Also, is the procedure/package owned by a different user to the one who owns the trigger ? In that case, you will need to also add the schema name as a further prefix.

You must also get the parameters exactly right. If there are the wrong number or the datatypes don't match, you will get an error message.