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

Home -> Community -> Usenet -> c.d.o.misc -> Re: OCIStmtExecute on an update query locks...

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

Original text of this message

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