BEFORE INSERT trigger compilation error
722037Sep 11 2009 — edited Sep 11 2009
Platform : Windows 2003 server, VC++ (Visual Studio 2008)
Database – Oracle
I have developed and attached BEFORE INSERT trigger on a table to insert unique number in a table. This trigger is using sequence to generate new key.
Database and trigger is being created by setup program. Sequence which is being used by trigger is being created by Server Application at runtime.
When run setup it is creating BEFORE INSERT trigger with compilation error because sequence used by trigger will be created later by Server Application.
Please help what step should I follow to create BEFORE INSERT trigger successfully.