1 Reply Latest reply: Jan 20, 2012 11:07 AM by Pam RSS

    apex tabular form

    Pam
      Hi,

      I have a question about a tabular form element. I am trying to set a date picker tabular form element with an item which is on a different region on the same page which is a date picker. When I add the row I get report error:
      ORA-01790: expression must have same datatype as corresponding expression
      Here is the tabular form element
      DISPLAY AS DATE PICKER
      DATE PICKER FORMAT MASK DATE PICKER(DD-MON-RR)
      DEFAULT TYPE ITEM (APPLICATION OR PAGE ITEM)
      DEFAULT P21_LABEL_REV
      REFERENCE TABLE OWNER RAWING
      REFERNCE TABLE NAME PROD_MSTR
      REFERENCE COLUMN NAME LABEL_REV (the field it is writing to in the table is a date field).


      Here is the item on a region format:
      NAME P21_LABEL_REV
      DISPLAY AS DATE PICKER(DD-MON-RR)

      Edited by: Pam on Jan 18, 2012 12:42 PM