Oracle Isolation Level

[Barry]

Anyone have a snippet of php code for oracle (oci_*) that sets the isolation
level to 'read uncommitted' that they could post here? I don't see one
built-in and don't know if it's an option on an existing oci function or if
it's just a query i submit via ociexecute.

Any help would be appreciated.

tia

[Rik Wasmus]

On Tue, 13 May 2008 20:14:33 +0200, Barry <no****@example.comwrote:

Anyone have a snippet of php code for oracle (oci_*) that sets the
isolation
level to 'read uncommitted' that they could post here? I don't see one
built-in and don't know if it's an option on an existing oci function or
if
it's just a query i submit via ociexecute.

I seldomly work with Oracle, is there a reason you can't send a 'SET
TRANSACTION READ COMMITTED;' to Oracle?
--
Rik Wasmus
[SPAM] Now temporarily looking for some smaller PHP/MySQL projects/work to
fund a self developed bigger project, mail me at rik at rwasmus.nl. [/SPAM]

[Barry]

"Rik Wasmus" <lu************@hotmail.comwrote in message
news:op***************@metallium.lan...

On Tue, 13 May 2008 20:14:33 +0200, Barry <no****@example.comwrote:

>Anyone have a snippet of php code for oracle (oci_*) that sets the
isolation
level to 'read uncommitted' that they could post here? I don't see one
built-in and don't know if it's an option on an existing oci function or
if
it's just a query i submit via ociexecute.

I seldomly work with Oracle, is there a reason you can't send a 'SET
TRANSACTION READ COMMITTED;' to Oracle?
--
Rik Wasmus
[SPAM] Now temporarily looking for some smaller PHP/MySQL projects/work to
fund a self developed bigger project, mail me at rik at rwasmus.nl.
[/SPAM]

That's what i was wondering...if i had to just send that query before i
wanted to do the rest of my processing or if there was a built-in oci
command (or if it was an optional arg to another oci command).

To answer your question, no, there's no reason other than wanting to be
uniform and use what may already be out there.

[Bart The Bear]

On Tue, 13 May 2008 13:14:33 -0500, Barry wrote:

Anyone have a snippet of php code for oracle (oci_*) that sets the
isolation level to 'read uncommitted' that they could post here?

Oracle does not support "read uncommitted" isolation level. No database
should ever support that level. Without ACID properties one cannot rely
on transactions. If you only need fast SQL-based search engine, try MySQL
with the tables created with ENGINE=MEMORY.


--
Christianity may be OK between consenting adults in private but should
not be taught to young children (Francis Crick)