Q: Oracle Row locking with Perl/DBI

From: Uwe Schneider <uwe.schneider_at_xlink.net>
Date: Tue, 11 Jan 2000 16:40:07 +0100
Message-ID: <387B4ED7.F7A1FE9E@xlink.net>

Hi experts,

I am wondering if it is possible to implement an explicit row locking in Perl/DBI/DBD-Oracle as this can be done in Pro*C:

EXEC SQL DECLARE CURSOR c FOR SELECT x, y FROM tab FOR UPDATE

OPEN c
loop

	FETCH
        [Do anything or wait for User actions]
	UPDATE tab SET y = ??? WHERE CURRENT OF c

end loop
CLOSE c

The DBD-Oracle interface is built upon OCI.

Best regards!

--
uwe.schneider_at_xlink.net Received on Tue Jan 11 2000 - 09:40:07 CST