Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> sql blocking problem

sql blocking problem

From: 이영한 <hotyoung_at_netnsec.com>
Date: Wed, 10 Jul 2002 05:37:30 GMT
Message-ID: <uKPW8.100856$nP6.10413306@news.bora.net>


I made homepage counter with Oracle.

Action of counter is executed to SQL statement such as lower part.

update t_count set work_date = '20020710', visit_cnt = visit_cnt+1

This program is made with Pro*C. After execute above SQL statement, execute commit statement.

By the way ..

At the same time, in case of program that execute above SQL statement ran much, above SQL is not processed in Oracle and phenomenon that become blocking happens.

How can i solve this problem?

please~~~ help.. me.. Received on Wed Jul 10 2002 - 00:37:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US