Does Oracle 8 have nested transactions?

[SemperFiDownUnda]

Does Oracle 8 have nested transactions?

I've got a stored procedure that was commiting and rolling back explicitly and this worked fine when ADO called the stored proceedure but when it was enveloped into a Distributed transaction the same SP fell over with a error saying COMMIT is not allowed in subordinate sessions.

Sorry but my experience with oracle is limited and I'm good with SQL Server which has this support. Just wondering if its a setting or just not supposed to be done that way in PLSQL.

Thanks

 

[jee]

Oracle8i does have "autonomous" transactions which are similar to nested transactions, but not exactly the same, however they are not allowed in distributed transactions. I looked in the 9i documentation to see if this restriction is lifted there, but I could not tell.

 

[SemperFiDownUnda]

Thank you.
It appears that doing a
SELECT ... FOR UPDATE in a UDF and removing the COMMIT and ROLLBACK statements work when under control of a Distributed transaction. Its good to know I wasn't missing something though.