Execute immediate calling a function that returns a boolean
400328Oct 21 2005 — edited Oct 21 2005I have a number of functions that return a boolean. These functions all work correctly when called from plsql. However I would know like to create dynamic sql that will call any of these functions and still be able to trap the boolean result.
I am using 'execute immediate' to call the functions, but the problem is that I cannot trap the boolean result. I have tried the following:
execute immediate 'function_name' using ABC into Bool1;
Can anyone tell me how to do this.
The only other way around this that I can see is to change the functions to procedures and use and OUT parameter for the boolean result. This is not ideal as these functions get used elsewhere that require them being functions and not procedures.