Re: OCIStmtExecute on an update query locks...

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Mon, 20 Feb 2006 21:36:56 +0000
Message-ID: <3jdkv11k2c698jl7uo8sorhhkc4bq5qvjh@4ax.com>

On 20 Feb 2006 01:16:19 -0800, "Herode" <cbrun_at_geomapgis.com> wrote:

> // ---> this one never returns....
> st = ::OCIStmtExecute( m_pService, m_pStmt, m_pErr, 1, 0, NULL, NULL,
>OCI_DEFAULT );
> if ( st != OCI_SUCCESS && st != OCI_SUCCESS_WITH_INFO ) {
> return false;
> }

Is the session waiting for a lock? Look at the DBA_WAITERS view for starters.

-- 
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

Received on Mon Feb 20 2006 - 15:36:56 CST