erodr154
Member
Greetings,
We recently added CFR audit for 20 tables on ur XE 7333 installation.
One of the tables F3112 has an issue when R31422 runs, the logs show that it happens during the CFR Update trigger execution.
The pointed line is the following query:
select program into programid from v$session where audsid = userenv('sessionid') and user in (select user from dual);
THis does not happen when user submits the job, it happens on scheduled runs only.
Does anyone have an insight into how the Sessions are generated in the DB that could cause this problem?
Looking at the query, audsid shouldl be unique, and there is no reason it would pickup more than 1 record. So, somehow AUDSID duplicates.
(error is, indeed, that the query fetches more than 1 line. trigger does not have exception handling).
We recently added CFR audit for 20 tables on ur XE 7333 installation.
One of the tables F3112 has an issue when R31422 runs, the logs show that it happens during the CFR Update trigger execution.
The pointed line is the following query:
select program into programid from v$session where audsid = userenv('sessionid') and user in (select user from dual);
THis does not happen when user submits the job, it happens on scheduled runs only.
Does anyone have an insight into how the Sessions are generated in the DB that could cause this problem?
Looking at the query, audsid shouldl be unique, and there is no reason it would pickup more than 1 record. So, somehow AUDSID duplicates.
(error is, indeed, that the query fetches more than 1 line. trigger does not have exception handling).