Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: dmaxwell on June 08, 2006, 06:13:39 am

Title: creating oracle triggers
Post by: dmaxwell on June 08, 2006, 06:13:39 am

Hi All,

I've been trying to generate triggers (pre insert and pre update) along with my tables when I generate ddl. The problem that I've been running into is that what is being generated is syntacially incorrect. EA seems to be generating the "on tablename" before any "before insert" statement. I've not found a way to tell EA this is a "before insert" trigger.

So I developed a work around...when I name the trigger I name it "triggername before insert" or "triggername before update". When I do this, EA generates ddl code that works.

So my question is...is this the way I should be doing this? Am I missing or misusing a property of the operation?

Thanks

Dana

Title: Re: creating oracle triggers
Post by: thomaskilian on June 08, 2006, 12:41:30 pm

DDL generation is not configurable except when using Tags. So you either go for your own code generation (you have to search the appropriate threads here) or you ask Sparx for an enhancement. There might be another solution, though.