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 -> Gateway

Gateway

From: Michael McGarrigle <mjm_at_barwonwater.vic.gov.au>
Date: 6 Apr 2000 12:00:25 +1000
Message-ID: <mjm.954986189@fraser>


I am using the Oracle transparent gateway to Ingres but I find that it is placing a table level lock on the Ingres table that I am reading.

I have set ING_SET="set lockmode session where readlock=nolock" but this is having no effect.

Any ideas would be greatly appreciated.

TIA --

Michael McGarrigle   	 Michael.McGarrigle_at_BarwonWater.Vic.Gov.Au
Information Systems      Barwon Water

61-67 Ryrie St Geelong Phone: +61 352 262326 Victoria 3220 Australia Fax: +61 352 218236 Received on Wed Apr 05 2000 - 21:00:25 CDT

Original text of this message

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