Stored Proc Call

Hi Everyone,

Is there a way to find out where the stored procedure created in database is being called in which process model through execute proc smart service?

Thank you!

  Discussion posts and replies are publicly visible

Parents
  • If you're keeping the Stored Procedure's name in a (text) Constant, you would simply be able to search dependents for that constant to see where it's called.  If for some reason the SP name is being hardcoded in different places, then searching for it will be a bit more difficult, though you can always try using the "expression" search in the global objects viewer. 

    Additionally if you're using the (older) Stored Procedure plug-in version of the smart service (versus the newer OOB version), you can look at dependents for the plug-in itself.  If you're using a!executeStoredProcedureForQuery(), you could at least do an expression search for places that call that.

Reply
  • If you're keeping the Stored Procedure's name in a (text) Constant, you would simply be able to search dependents for that constant to see where it's called.  If for some reason the SP name is being hardcoded in different places, then searching for it will be a bit more difficult, though you can always try using the "expression" search in the global objects viewer. 

    Additionally if you're using the (older) Stored Procedure plug-in version of the smart service (versus the newer OOB version), you can look at dependents for the plug-in itself.  If you're using a!executeStoredProcedureForQuery(), you could at least do an expression search for places that call that.

Children