This content has been marked as final. Show 1 reply
i don't believe object view "instead of" triggers allow for a "returning" clause, so it's not possible to use that mechanism to return the trigger-assigned value.
two other possibilities include:
1) have your code instead call a stored function which assigns the id (rather than the trigger) and then inserts the object; return the assigned value to your calling code.
2) modify your trigger to set a package variable with the assigned id value; inspect the package variable after insert.
hope that helps...