Forum Stats

  • 3,851,925 Users
  • 2,264,053 Discussions
  • 7,904,906 Comments

Discussions

BEFORE INSERT trigger compilation error

722037
722037 Member Posts: 6
edited Sep 11, 2009 3:55PM in 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
Tagged:

Answers

This discussion has been closed.