Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Trigger will not fire event

Trigger will not fire event

Trigger will not fire event

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.

RE: Trigger will not fire event

Maybe the Trigger doesn't have access to the ALTER ANY USER permission  (or whatever it's called).

RE: Trigger will not fire event

I didn't think you could do this kind of thing in a trigger - or in any pl/sql block. Aren't you restricted to DML statements unless you explicitly prepare and execute DDL or Alter User (can't remember the TLA  for that) stuff?

Cargill's Corporate Web Site

RE: Trigger will not fire event

You go through dynamical plsql block using dbms_sql,dbms_open etc stuff. Because plsql tends to be early binding we cannot issue dml commands

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

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.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close