Problem with OraOLEDB - select returns deleted rows

From: MadeOfRose <mehmetgulden_at_gmail.com>
Date: 7 Jan 2006 01:45:07 -0800
Message-ID: <1136627107.775991.123940@f14g2000cwb.googlegroups.com>

hi
i am so new on oracle.
My problem is i cannot delete rows from a table.Look like deleted but it is not :D

i am working on web application which works with ASP. And i deleted some rows from isqlpus interface. But when i list records from ASP page i still see the rows which i deleted before,i do not see the rows when i run the same listing query from isqlplus

i use OraOLEDB at ASP side,it is basic connection with ADO here is the some part of my ASP code

'This is how i connect to DB

Dim Conn
Function OpenConnection()

	If isObject(Conn) Then
		Exit Function
	End if
	Set Conn = server.CreateObject("ADODB.CONNECTION")
	Conn.ConnectionString =

Provider=OraOLEDB.Oracle;Password=oracle;Persist Security Info=True;User ID=SYSTEM;Data Source=orcl

	Conn.CursorLocation = aduseServer
	Conn.Open()

End Function

'This is how i run the query

conn.execute "Select * from YAZILAR"

'This is what i runned from isqlplus interface
delete YAZILAR where DOKUMANID>'360'

Thanks for any help Received on Sat Jan 07 2006 - 03:45:07 CST