Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: no row, but index violated when insert
A copy of this was sent to Thenardier_at_pk.POBoxes.com (ªü´ö Thenardier) (if that email address didn't require changing) On Tue, 17 Nov 1998 23:42:34 GMT, you wrote:
>
>hello,
>
>i've got a problem. i'm trying to insert a new record into a table
>thru form. transaction fails but no message appears. i know it cos
>it returns *zero* row when i count (*) from the targeted table in
>sql+. ok. i try to insert the new record in sql+ and it ends up
>with a message telling me that the action has violated the unique
>index of the table.
>
sounds alot like you didn't commit in the form. If you use the form to insert a row and then switch windows to sqlplus and "select * from that_table" you won't be able to see the uncommitted rows the form has inserted.
try committing the form...
>can anyone tell me what's happening? and more important, how to
>handle it? as far as i know, i'm the only one who is working with
>that table. i don't think i can drop the table and rebuild it -
>cos that's an interface table in Oracle Order Entry... :(
>
>pls help! thanx! btw, i can't wait till next time i come to the
>newsgroup. so pls email me if u can.
>
>
>thenard
>-------
>pls remove pk. in reply, thanx.
>¦^Âîɽçâpk. K ±¼, ÃÂÃÂ.
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
-- http://govt.us.oracle.com/ -- downloadable utilities ---------------------------------------------------------------------------- Opinions are mine and do not necessarily reflect those of Oracle Corporation Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it.Received on Wed Nov 18 1998 - 00:00:00 CST