"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message
news:RYudnVRLuuKaZl3enZ2dnUVZ_sednZ2d_at_comcast.com...
>
> "MadeOfRose" <mehmetgulden_at_gmail.com> wrote in message
> news:1136627107.775991.123940_at_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
> >
>
> did you issue a COMMIT in SQL*Plus?
>
> did you test your ASP query in a 2nd SQL*Plus session?
>
> likely you will find the same problem in any 2nd sesson (ASP, SQL*Plus,
> TOAD, Raptor, etc.) if you did not issue a COMMIT
>
> by default, Oracle does not automaticaly commit data changs (INSERT,
UPDATE,
> DELETE), which is different from some environments you may be used to.
>
> ++ mcs
>
>
Also it is a very bad idea to logon as system or sys
Jim
Received on Sun Jan 08 2006 - 10:31:27 CST
