On Dec 18, 2008, at 4:19 PM, Ketema Harris wrote:
The following is a snippet from a trigger i am using:
_mycompositeType.user_id = (OLD).mycompositeType.user_id;
...do some stuff... --notice that assigning from the trigger record
works
but later on...
(new).mycompositeType.transaction_id
The following is a snippet from a trigger i am using:
_mycompositeType.user_id = (OLD).mycompositeType.user_id;
...do some stuff... --notice that assigning from the trigger record
works
but later on...
(new).mycompositeType.transaction_id := _transaction_id;
Fails with syntax error at or n
