Re: Proposal for new $h->{ReadOnly} attribute

Re: Proposal for new $h->{ReadOnly} attribute

am 31.05.2007 20:14:08 von jkstill

------=_Part_1142_4881365.1180635248086
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On 5/4/07, Scott Smith wrote:
>
>
> I don't know if/how other databases implement this feature, and give it
> such a possibly misleading name. Does anyone else?
>
>
I wouldn't consider it misleading.

This is the way SET TRANSACTION works in Oracle, regardless of whether
or not it is read only.

I believe this correspond to the ANSI standard SET TRANSACTION REPEATABLE
READ
with the added functionality of not allowing DML when set to READ ONLY.

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

------=_Part_1142_4881365.1180635248086--