Database Administration (MOSC)

MOSC Banner

Table Before Insert Trigger doesn't fire when statement is Insert row into table from select * from

edited Jun 16, 2009 7:13PM in Database Administration (MOSC) 2 commentsAnswered
 We have a table T1 with columns c1, c2, c3 and c4.   Column c1 and c4 are not null.   C4 is "auto" populated with a before insert trigger.  The view is V1 which only provides the values for c1, c2 and c3.  When the statement "insert into T1 select * from V1 (a view)  is run the error  ORA-00947: not enough values, Batch 1 Line 1 Col 20.    It seems when trying to insert data into a table  via a select from a view the table trigger is not recognized.    If values are supplied for ALL columns via the view then the trigger does execute.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center