Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

first record insert: but, unique constraint error!!

Status
Not open for further replies.

BlueByte

Programmer
Jul 18, 2003
28
IN
hi!
table_1 has constraint pk_table_1 on columns a,b,c,d,e.

am tryin to insert *first* record thro' a form...
but, i get an error: ora-00001: unique constraint error -
constraint pk_table_1 violated.

this beats me..coz this is the first record iam inserting
into this table...

cud anyone pls send a fix??

thnx,
blubyte
 
I suppose you try to insert your record twice: 1 time Forms processes new record automatically; then you duplicate it manually. Another possible reason is the same with database trigger. Check triggers (both Forms and database).

Regards, Dima
 
hi dima!
thnx for the reply.

wud u pls elaborate with an example?
i dint get wot u meant by *manually duplicating*..

pls reply asap..


regards,
blubyte
 
Is it your form? Is it your first form?

Regards, Dima
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top