SQL & PL/SQL

Platform : Windows 2003 server, VC++ (Visual Studio 2008)
Database – Oracle

Hi,

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.


Thanks,

Vijay Singh
EDISPHERE Software