Re: Precompiler LOCK TABLE doesn't work

mmm_at_icf.hrb.com (MAX M. MAGLIARO) writes:

>I have a PROFORTRAN application, under ORACLE 7.0.16.6.2, that does
>the following:
 

>EXEC SQL LOCK TABLE FRED IN EXCLUSIVE MODE
 
>There is no COMMIT, the code goes to sleep (but keeps running... it
>does NOT terminate) after this...

Seems to me someone else has locked a row or rows from FRED. Your code then waits infinitely for that lock to be released. Use EXEC SQL LOCK TABLE FRED IN EXCLUSIVE MODE NOWAIT instead.

>the table isn't locked. I can still update/insert/delete from
>SQLPLUS in another window.
> [REST DELETED]
All the rows? Or only some of them.

Jukka keto

-- 
Internet      : jketo_at_cs.joensuu.fi [128.214.14.19]
X.400 (suomi) : GN=JKETO;OV1=CS;O=JOENSUU;ADMD=FUMAIL;C=FI
Tel           : +358 73 736210                             
Bread & Butter: Large scale c/c++/oracle/unix/client-server programs