This content has been marked as final. Show 2 replies
You need to determine the exact error in the procedure that is being created by enableversioning. If you query the dba_errors view, you should be able to get this information. There will most likely be errors in a procedure named WM$COLTG_OBA_TEST3_U.
Also, if you are able to post the body of the trigger, then that would help in determining what is causing the error.
Be sure that you are using the latest version of Workspace Manager. For a 10.2 database, this is currently 10.2.0.3.1.
"+1.10 Triggers on Version-Enabled Tables Version-enabled tables can have triggers defined; however, the following considerations and restrictions apply: ¦ Only per-row triggers are supported. Per-statement triggers are not supported. ¦ Only whole-row triggers are supported. *Before-update and after-update triggers for specific columns are not supported*.+" - "Application Developer’s Guide - Workspace Manager (B14253-01, 10g Release 2) [pg 1-23]