APEX

Hi

I have two forms in a page, each based on the same table and hence there are items on the page that have a 'Source Type' of 'Database Column' and the same database column specified in 'Source Value of Expression'. The only difference between my two forms is that 1 particular column/item is displayed as text area in the 1st form and as a 'text are with html editor' in the 2nd form. I conditionally display 1 form or the other based on the user preference.

When I update the table through either forms, I see no problem. however, when I try to create(insert) a new record using either of the 2 forms, when I click on the create button, I get the error ': PL/SQL: ORA-00957: duplicate column name ORA-06550: line 1, column 7: PL/SQL: SQL Statement ignored'.

I appreciate any help. Thanks.

Suni