working in 11G
I have a stored proc that uses who_called_me to get the schema name and parse it. It then uses the pieces and a cursor to build the schema names that are sued in a dynamic sql string to execute a data collection procedure in a set of schemas. The proc that uses who_called_me is a master schema and the other schemas are local schemas, that is, they are specific to an activity where the master holds most of the common data that the local schemas need, such as a user table, an activity type table, a logon history table, etc.
When I execute the stored proc using an anonymous plsql block
begin
rpt_run_fill;
end;
/
I cannot get any values returned from who_called_me. I've added put_lines in rpt_run_fill and no values are returned by who_called_me. but if I call rpt_run_fill from a stored proc, I get the values back. And reason why this is happening?
Thanks in advance.
Jim