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.

Tell me how to debug the report?

0 Answers  

---

what is the difference between po_vendors & po_headers_all? does po_vendors relate to opeating unit?

2 Answers   CTS,

---

In thet custom.pll what are the events we can write.

2 Answers   IBM,

---

Where we can write a PL/SQL code in report triggers?

2 Answers   IBM,

---

What is the Use of User Exit in Oracle apps and when we are developeing the new report you need to pass one parameter called P_CONC_REQUEST_ID,what is the use of this parameter and is it mandatory.Can't we develop report without this User exit's and P_CONC_REQUEST_ID parameter

12 Answers   TCS,

---

what are external tables? how can we use external table instead of sql * loader to load data from flat file to staging table?

1 Answers   IBM,

---

What is the use of format trigger?

4 Answers   Cap Gemini, IBM,

---

wht r the basetables of customer interface?

2 Answers  

---

in one report using two layout models.if yes how to do

4 Answers   Covansys,

---

what are the prerequisite set ups for inter organization transaction?

1 Answers   Scan Steel,

---

what are the different calculation columns available in reports?

1 Answers  

---

can we use look up type instead of a pofile option?or valueset?is it possible how?

0 Answers   Cap Gemini,

---