Do TQueries and TStoredProc share the same transaction context?

If we use the same DatabaseName for a TStoredProc and some TQueries, will a
COMMIT inside the stored procedure commit the changes made by the queries?

Will TDatabase.InTransaction report this correctly?

Will this be the same for MS SQL 6.5, MS SQL 7.0/2000, and Oracle 7.3/8 ?

Thanks