Hi,
Has the sequence reached it's maximum value?
Can you provide the DDL for the sequence, and the maximum value of the table column that receives the sequence (considering an ascending sequence)?
Regards,
AM
-----Original Message-----
From: CHANDRASEKARAN Vinodh Paramasivan
[mailto:oracledba-ezmlmshield-x56762336.[Email address protected]
Sent: sexta-feira, 24 de Dezembro de 2004 14:47
To: LazyDBA Discussion
Subject: ORA-00001 while using Instead of Trigger
Hi all,
I have an instead of insert trigger on a view which is select * from <T1>. In the trigger we are inserting into T1 in addition to some inserts in other tables.This was working fine till yesterday. Now we are getting an ORA-00001 exception while inserting the records into the view. But the records are getting inserted into the table T1. The table has a composite primary key with one of the columns generated from the sequence. There were 29 inserts. We received the ORA-00001 error 29 times and 29 records were also inserted into the table. There was no jump in the sequence values.
StackTrace:java.sql.SQLException: ORA-00001: unique constraint (XXXXX.XPKPGM_PRT_PHYS_HST) violated
ORA-06512: at "XXXXX.PGM_PRT_PHYS_HST_VW_INS", line 127
ORA-04088: error during execution of trigger 'XXXXX.PGM_PRT_PHYS_HST_VW_INS_TR'
Please let me know how this could happen?
TIA
Vinodh
Confidentiality Statement:
This message is intended only for the individual or entity to which it is addressed. It may contain privileged, confidential information which is exempt from disclosure under applicable laws. If you are not the intended recipient, please note that you are strictly prohibited from disseminating or distributing this information (other than to the intended recipient) or copying this information. If you have received this communication in error, please notify us immediately by return email.
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html
------------------------------------------
This message may contain confidential information or privileged material,
and is intended only for the individual(s) named. If you are not in the
named addressee you should not disseminate, distribute or copy this e-mail.
Please notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system.
E-mail transmission cannot be guaranteed to be secure or error-free as
information could be intercepted, corrupted, lost, destroyed, arrive late
or incomplete, or contain viruses. The sender therefore does not accept
liability for any errors or omissions in the contents of this message
which arise as a result of e-mail transmission. If verification is
required please request a hard-copy version.
Vodafone (Portugal)
Oracle LazyDBA home page