| problem with after trigger [message #371897] |
Mon, 18 December 2000 16:11 |
craig curtin
Messages: 1
Registered: December 2000
|
Junior Member |
|
|
hi,
i'm trying to use a sequence to join two tables A & B.
i have a trigger on A that gets the sequence value
and tries to insert it to A, then inserts some data in
B (createDate, ..., as well as the sequence #).
but i keep getting errors.
anyone have some code that does similar things?
please post/email.
i forgot to grab my code from work, but it was generating an error on the :new.blah ...
any trigger references appreciated. this is oracle 8.1.6.
thanks,
craig
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
