2 Replies Latest reply: Dec 3, 2012 3:02 AM by Nina RSS

    How to refresh view attributes

      I have a view object based on an empty entity, and defined by this query:
      SELECT *
      FROM TABLE(db_j_week_workplan.query_func ( :TheOrganisationNum, :TheOfficeNum, :TheSectionNum, :TheDeptNum, :TheSectorNum, :TheWorkType, :TheJobNum, :TheIdNum, :TheEmpName, :TheHoursType,:TheDateFrom, :TheDateTo, :TheOrderByDay ))

      the function returns WEEK_WORKPLAN_TAB which is a collection type based on an object type, that is definf in the db.
      I changed some attributes in the object type in the db. How can I make the view take the changes without deleting it and creating again for every change?

      Thank you,