1 Reply Latest reply: Nov 14, 2012 2:20 PM by Christina Cho-Oracle RSS

    APEX$_WS_ROWS_T1 invalid trigger after update to 4.2

    aracila
      Hi All,

      Can you please help me with this trigger.
      After update from 4.0.4 to 4.2 we have this trigger(APEX$_WS_ROWS_T1) INVALID in all schemas.

      Trying to compiling give me next message.
      1     28398     PLS-00103: Encountered the symbol "end-of-file"

      Thanks a lot,
      Andrei
        • 1. Re: APEX$_WS_ROWS_T1 invalid trigger after update to 4.2
          Christina Cho-Oracle
          Andrei,

          Try to fix the invalid trigger by going into each workspace Administration > Manage Service > Websheet Database Objects (on the right side region "Manage Meta Data). Click Validate Websheet Database Objects. The button "Correct Invalid Object" will display if any of APEX$ objects are invalid. Click the button to re-create the object. If you are upgrading from 4.0 to 4.2, APEX$_WS_ROWS_T1 is one of the object we automatically upgrade and shouldn't invalidate. Not sure what caused.

          Regards,
          Christina