Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can't commit changes to table

Re: Can't commit changes to table

From: Richard \ <rgadd.deletethisforreply_at_qni.com>
Date: 22 Feb 1999 04:29:45 GMT
Message-ID: <01be5e2c$a2f9bb80$241f7ed1@rickg>

Oracle performs a rollback automatically if an error occurs.

jvnet_at_excite.com wrote in article <7aitv6$r65$1_at_nnrp1.dejanews.com>...
> I ran a SQL script to change a column in a table from CHAR(6) to CHAR(*).
 I
> run a "desc" after and no changes have taken place. I'm assuming a
rollback
> occurred even though I appended "commit" to the end of the script. What
would
> cause a commit to not occur in this type of situation ?
>
> Thanks
> John
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
 

>
Received on Sun Feb 21 1999 - 22:29:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US