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 tables of auto invoice.

2 Answers  

---

what is difference between procedure and function

5 Answers   E Logic,

---

how many sections are there in report?

1 Answers  

---

If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

5 Answers   Wipro,

---

what is Flex mode and Confine mode?

2 Answers   Rapidigm,

---

we have select statement in that two exceptions that returns no value. In that which exception will raise?

2 Answers  

---

What is the package?

2 Answers  

---

in interface and conversion if 10 records are error out we can't load the records?if >10 we have to insert,if we not insert we need to gernerate error how u can achieve?

1 Answers   Oracle,

---

in ap_terms table what data will be stored

1 Answers  

---

Can you define an erp system?

0 Answers  

---

Matrix Report: Simple, Group above, Nested

1 Answers  

---

What is template?

2 Answers  

---