I am calling a stored from within another stored procedure. When I execute the calling stored procedure I get the error message:
Error PLS-00222: no function with name 'Generator' exists in this scope
I don't have a function. My stored procedure is named "Generator". Why does it think I am executing a function?
EXECUTE IMMEDIATE Generator ('tTable',inParam) INTO newVal;