| |
GeekInterview.com > Interview Questions > Oracle > PL/SQL
| Print | |
Question: Pipe Function and Mutating Trigger
Answer: 1) Why we use pl/sql array rather than cursor?
2) In which condition we use function overloading?
3) What is pipe function?
4) What is the mutating trigger? What should be the condition? |
| March 03, 2009 15:50:00 |
#3 |
| ananth.oracle |
Member Since: March 2009 Total Comments: 3 |
RE: Pipe Function and Mutating Trigger
|
The Oracle mutating trigger error occurs when a trigger references the table that owns the trigger. The best way to avoid this error is use autonomous transaction in triggers so that the child transaction will be independent of the parent transaction.
The Oracle DBMS_PIPE package provies a mechanism that can be used for indirect communication between two or more co-operating Oracle sessions. |
| |
Back To Question | |
