| Drawback of DBMS_PIPE [message #515228] |
Fri, 08 July 2011 20:29  |
muktha_22
Messages: 527
Registered: December 2009
|
Senior Member |
|
|
He'll Every one,
One of my senior DBA opposing for using:
DBMS_PIPE To send intimation about every transactions through triggers.
What is the problem of using this package. If it is a problematic, then what is the alternatives...
Thanks and regards,
Muktha
|
|
|
|
| Re: Drawback of DBMS_PIPE [message #515230 is a reply to message #515228] |
Fri, 08 July 2011 20:38  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
do as below so we can know complete Oracle version & OS name.
Post via COPY & PASTE complete results of
SELECT * from v$version;
>DBMS_PIPE To send intimation about every transactions through triggers.
WHY?
What business problem does this solve?
What is at other end of the PIPE?
>What is the problem of using this package.
Does primary application cease to operate when PIPE is broken?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
