I created a procedure that executes an ALTER USER statement and it works when I run it stand alone. But then I created a trigger that is supposed to fire off this procedure when a before update event on a column of an oracle table takes place. This table is application specific, so I am testing this through the application process. I know the column updated, but the procedure didd not execute. I've got the system privs set to execute any procedure. Created a public synonym for that procedure. Is there a way to trace this event so I debug this problem further. Thank u for yur time. Leida.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.