Using custom functions in GORRSQL

We have a custom function that returns 'Y' if a person passes all the various criteria for being considered 'faculty.' We're using that with various other programs and areas in order to be consistent. I need to be able to call this custom function to create the faculty role. It's compiled into our custom schema (its) but the dba then granted execute on it to baninst1. That allowed me to click validate in GORRSQL and be able to save without getting insufficient privileges. I have the rule active. I can run the function as sql and connected as its: select its.gzkgenl.gzfmlis('238239','faculty') from dual; This returns Y for the individual. However, when I go into goatpad and reset the pin for the individual in order to recalc her roles, she isn't being assigned the faculty role nor do any errors pop up. We expect there is another schema that needs granted execute rights to the function but are not sure who that would be and don't know where to look in order to troubleshoot it. Can anyone help?

Syndicate content