Hello!
I'm connecting to Oracle 7.3.4 database from my ASP using ODBC (Microsoft ODBC for Oracle).
There are also several calls to pl/sql proderures from ASP.
My problem is, that after every succesfull pl/sql procedure call changes are commited into database, even if I don't have COMMIT statement in my pl/sql procedure.
I thing that this is done by ODBC.
Does anyone know how to prevent ODBC NOT TO force the commit.
I need this answer very fast .
Thank you,
Tomaz

Instance:
dim db
set db=session("db")
dim comm
Set comm=Server.CreateObject("ADODB.Command")
Set comm.ActiveConnection = db
comm.CommandText = "BEGIN DECLARE p1 VARCHAR2(255); BEGIN p1:=my_procedure('1',526); END; END;"
comm.execute