question about dbms_pipe!
From: Brandon Lee <brand_at_tm.net.my>
Date: Mon, 1 Mar 1999 10:39:26 +0800
Message-ID: <36d9fe2f.0_at_news.tm.net.my>
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?
Date: Mon, 1 Mar 1999 10:39:26 +0800
Message-ID: <36d9fe2f.0_at_news.tm.net.my>
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! Received on Mon Mar 01 1999 - 03:39:26 CET