Looks like the trigger isn't working correctly under 9i. I have only tested
8.1.7, but I plan to test with 9i shortly.  I'm off for a week's skiing
tomorrow, so it will probably be the New Year before I'm able to check this.

In the meantime, if you find a solution, please let me know. I doubt it
should be very hard to sort out. In my experience, going from 8.1.7 to 9i
isn't usually too problematic.

Regards,
Rod

----- Original Message -----
From: "Christopher Axe" <caxe@y...>
To: "ExpertJ2EE with RodJohnson" <expertj2ee_with_rodjohnson@p...>
Sent: Friday, December 20, 2002 10:13 PM
Subject: [expertj2ee_with_rodjohnson] Re: I only have oracle 8.0.5 database


> Never mind about the 8.0.5 database I upgraded to 9i. But I get the
> following error massage when doing a insert into the performance database
>
> Error on line 0
> insert into performance (id, date_and_time, show_id, price_structure_id)
> value
>
> ORA-00001: unique constraint (DEMO.SYS_IOT_TOP_30333) violated
> ORA-06512: at "DEMO.PERFORMANCE_SEAT_STATUS", line 2
>
> It appears that no unique data is selected for insertion.
>