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.