Re: OCI time out !

"Oscar" <oscar_ll_at_jofre.com> wrote in message news:<am6nts$go2$1_at_nsnmrro2-gest.nuria.telefonica-data.net>...
> How to determine the time out when a tabla is locked ? I have something like
> this, but what about if i make a select for update and another one have make
> the same I got with a lock undetermitated ? I mean i would like to get lockd
> for 30 secons after that get a code of error because tha table is lockd ....

You probably want to specify "NO WAIT" in your select for update statement. That will immediately return control to you if you cannot acquire the lock. Your application could then wait 30 seconds and try again, prompt the user, whatever.

Justin Cave

>
>
> if (olog(&lda, hda, sz, -1, szu, -1, szt,-1, (ub4) OCI_LM_DEF)) {
> printf ("No se puede establecer conexion con Base de Datos %s\n", sz);
> exit(1);
> }
>
> >> OOPENS, opens the specified cursor.
> if (oopen(&cda, &lda, (text *) 0, -1, -1, (text *) 0, -1)) {
> printf ("No se ha podido crear el cursor para acceder al
> diccionario\n");
> exit(1);
> }
>
>
> thanks ! Oscar
Received on Tue Sep 17 2002 - 16:24:55 CDT