Answer / kiran kumar

Triggers:
--------

1)Defined with create trigger
2)The data dictionary contains source code in the user_triggers.
3)Implicitly invoked
4)Commit, save point and rollback are not allowed(TCL)

Procedures:
-----------

1)Defined with create procedure
2)Data dictionary contains source code in user_source
3)Explicitly invoked
4)Those are allowed

Note: compare both ones with numbers mentioned..

Answer / suresh.somayajula

1. Triggers are implicitly invoked but

procedures are explicitly invoked.

2. in Triggers TCL commands are not allowed.

TCL commands are allowed in Procedures.

what are the types of interfacing?

3 Answers   TCS,

---

How can u call a standard interface program from sql or pl/sql code?

3 Answers   Satyam,

---

What is multi org?

6 Answers   Accenture, CTS,

---

What are the Import Programs We need to run after creating Interface table for all modules

1 Answers   Accenture,

---

Can function be overload?

4 Answers  

---

what is inbound and outbound interface?

2 Answers  

---

types of invoices?

7 Answers   BelAir Store, Convergys, Wings Biotech,

---

what is back order in OM

4 Answers   IBM, Oracle,

---

what is lexical parameter?

3 Answers   TCS,

---

Hi  Friends this is preetham, i am  searching for job on oracle apps(technical) i put 3 years fake exp, so any one  please could you help me for realtime interview  questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify

0 Answers   IBM,

---

what is the error you will get if field is referenced in wrong repeating frame?

1 Answers  

---

while running a interface if we get 100 records as erors. how to debug it.

2 Answers   Zensar,

---