Re: Rows does not show up when i modify with isqlplus

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Sun, 8 Jan 2006 22:21:31 -0500
Message-ID: <WeadnRW9mJggS1zenZ2dnUVZ_v2dnZ2d@comcast.com>

"Jim Kennedy" <jim dot scuba dot kennedy at gee male dot com> wrote in message news:dKGdnbq_q_FTXlzenZ2dnUVZ_vudnZ2d_at_comcast.com...
>
> "MadeOfRose" <mehmetgulden_at_gmail.com> wrote in message
> news:1136654255.213086.52390_at_z14g2000cwz.googlegroups.com...
>> hi all
>> i am new on oracle and this group
>> do anybody know why i cannot see updates from my asp code which added
>> with isqlplus.
>> i see the rows after a while from OraOLEDB
>>
>> i use reqular CREATE table STATEMENT and INSERT INTO statement with
>> isqlplus.
>> and i use OraOLEDB with my ASP page.
>>
>> thanks for any help
>>
> Did you commit?(eg commit;) No. That's why. Learn about transactions.
> In
> Oracle there isn't an autocommit mode. (thank god)
> Jim
>
>

Actually, SQL*Plus has SET AUTOCOMMIT ON, and there are ways to do autocommit with the OCI, for instance:
http://download-east.oracle.com/docs/cd/B19306_01/appdev.102/b14294/reference030.htm#i1094412 Also "By default, OraOLEDB is in an autocommit mode" (http://download-east.oracle.com/docs/cd/B19306_01/win.102/b14311/using.htm)

++ mcs Received on Sun Jan 08 2006 - 21:21:31 CST