owa_util.who_called_me or owa_util.get_procedure, ora-6502
Has anyone ever figured out how to prevent ora-06502 when calling owa_util.who_called_me or owa_util.get_procedure.
Of course this works perfectly in a trigger for auditing web based forms on a table. However once a back-end job is launched via dbms_job or scheduler then inserts get rejected via the 6502.
I've tried to null the values and exception the 6502 to no avail. Thanks for any input.
Edited by: user2782485 on Oct 21, 2012 12:32 PM