Re: question about dbms_pipe!

Brandon Lee wrote:
>
> hi anyone,
> i got a problem at hand which i need some assurance that it will work; or
> else i would not venture into. i am using developer2000 and oracle7.3 to
> create a sale order system whereby sale person enters sale order and
> depending on what is entered, certain sale orders might need higher level
> officer to approve. Problem is when a sale order requires approval, i was
> thinking of using dbms_pipe to send message from the sale person to whoever
> been assigned with manager role. So when the manager logon, there will be
> timer setup to check if there is any sale order to approve. My question is:
> will this work when there are more than one person assigned with manager
> role and they logon at the same time. Eventually, this whole thing would
> depend on the timer, wouldn't it?
>
> Alternatively, i can use a table to store unapproved sale order and have the
> client side to check on this table using timer. Which way is more efficient
> and easy to code?
>
> thanks in advance!

Some things to think about:

pipes are non-transactional - so if you send a pipe and then the data entry person rolls back (or does clear_form), then the manager gets a message for no reason....

pipes are "single read" namely, if two people poll to see the same pipe message only 1 will get it...

A possible resolution to both the above problems is to use dbms_alert instead of dbms_pipe.

Cheers

-- 
==============================================
Connor McDonald
BHP Information Technology
Perth, Western Australia
"Never wrestle a pig - you both get dirty and the pig likes it..."