Creating Alerts in Oracle Apps 11i

I want to create an update/insert/delete alert on a certain column of a table in Oracle Apps without using triggers...
I know that Oracle Apps 11i has a facility which allows me to create an alert on the whole table...
but my requirement is only for a particular column not the whole table
Please can anyone advice....
meetkahutoAsked:
Who is Participating?
 
wandidj1Commented:
alright then, you just using dbms_alert packages.
you can ask me if you have a problem about dbms_packages


wandi
0
 
wandidj1Commented:
to change the structure and making additon to oracle application table is dangerous.
however if you'd like to make a trigger.

you can create a trigger contained dbms_alert using dba studio or from sql plus.

example:
CREATE TRIGGER emptrig AFTER INSERT OR UPDATE OR DELETE ON emp
    BEGIN
      DBMS_ALERT.SIGNAL('emp_table_alert', 'message_text');
   END;

For complete reference check this out:
http://technet.oracle.com/doc/server.815/a68001/dbms_ale.htm


wandi
0
 
meetkahutoAuthor Commented:
Thanks for the reply, but Trigger is not the option.
            The moment the table gets updated or a new data gets entered into the table, i can run a PL/SQL program. So I want to put a logic inside the PL/SQL program which can figure out which column got updated, and if the Column that got updated is the one i am monitoring. Then return the last value and the new value in that column.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
meetkahutoAuthor Commented:
Thanks for the reply, but Trigger is not the option.
            The moment the table gets updated or a new data gets entered into the table, i can run a PL/SQL program. So I want to put a logic inside the PL/SQL program which can figure out which column got updated, and if the Column that got updated is the one i am monitoring. Then return the last value and the new value in that column.
0
 
meetkahutoAuthor Commented:
Thanks for the reply, but Trigger is not the option.
            The moment the table gets updated or a new data gets entered into the table, i can run a PL/SQL program. So I want to put a logic inside the PL/SQL program which can figure out which column got updated, and if the Column that got updated is the one i am monitoring. Then return the last value and the new value in that column.
0
 
MoondancerCommented:
Please update and finalize this old, open question.  Please:

1) Award points ... if you need Moderator assistance to split points, comment here with details please or advise us in Community Support with a zero point question and this question link.
2) Ask us to delete it if it has no value to you or others
3) Ask for a refund so that we can move it to our PAQ at zero points if it did not help you but may help others.

EXPERT INPUT WITH CLOSING RECOMMENDATIONS IS APPRECIATED IF ASKER DOES NOT RESPOND.

Thanks,
Moondancer - EE Moderator

P.S.  Please click your Member Profile, expand View Question History to navigate and update all your open and locked questions.
0
 
MoondancerCommented:
Zero response, thus finalized.
Moondancer - EE Moderator
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.