Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: help help help urgent
micind wrote:
>
> Hi
> We are using oracle 8 and developer 5.0
> Background:
> Sales invoice entry form and sales order entry form both are running on
> different win-95 machines. Each form is using "POST" built in procedure of
> oracle.
> When a sales order number is queried, changed and posted on one computer(but
> not yet committed). The another user is working on sales invoice entry and
> trying to get items being ordered in different sales order other than the
> one posted by that user.
> Problem:
> The second user(one who is trying to prepare invoice) is getting message
> 'working.....' while getting sales order details. When the sales order
> details are committed, the invoice user get access to sales order details.
> Why?
>
> Invoice entry form contains sales_order_item block use only to query the
> items from sales_order_item table.
>
> sales_invoice table (sales_order_code) is referenceing sales_order_item
> table.
> Pls contact
> micind_at_bom3.vsnl.net.in
Even though different, you may want to see if they are getting caught on locking each other on say a surrogate key (for example a sequence number)...if they are both inserting, updating or deleting a row with a common sequence number then you would get the behaviour you describe...
have a look at v$lock to see whose is locking who...
HTH
--
"Some days you're the pigeon, and some days you're the statue." Received on Mon Aug 16 1999 - 04:05:00 CDT