APEX

Hello:

l created a page which is a form to update a table. The UPDATE process was created as Automatic Row Processing. When I submit the form, the table was updated with no error message.

There is a field in the table which needed special handling in order to be updated. So, I had to change my Automatic Row Processing process to a PL/SQL block process. When I submit this form, I receive the following error message:
ORA-12899: value too large for column "MDD"."ORGANIZATION"."CONTACT_SALUTATION" (actual: 6, maximum: 5).

I do not understand how changing the processing from Automatic to a PL/SQL block would generate this message. My PL/SQL block statement doesn't show any column widths. Everything else on the page remained untouched.

Can someone help me? Do I have to declare variables with their column widths and then set the declared values to equal to my page item?

For example:

DECLARE
vSALUTION varchar(2) 5;
BEGIN
update
 test.organizaton
    set
      vSALUTATION=:P14_SALUTATION
where
      ORG_KEY=:P14_ORG_KEY
;
END;
{code}
Thank you for the help.

This is my current PL/SQL block statement:
{code:java}
BEGIN
 update 
    TEST.ORGANIZATION
     set
       SPONSOR=:P14_SPONSOR,
       SUBSCRIBER=:P14_SUBSCRIBER,
       PROVIDER=:P14_PROVIDER,
       NAME=:P14_NAME,
       STATUS=:P14_STATUS,
       EXTERNAL_ID=:P14_EXTERNAL_ID,
       TIN=:P14_TIN,
       REGION=:P14_REGION,
       ADDRESS_LINE_1=:P14_ADDRESS_LINE_1,
       ADDRESS_LINE_2=:P14_ADDRESS_LINE_2,
       CITY=:P14_CITY,
       ZIP=:P14_ZIP,
       ZIP_PLUS_FOUR=:P14_ZIP_PLUS_FOUR,
       LIVE_DATE=:P14_LIVE_DATE,
       CONTACT_SALUTATION=:P14_SALUTATION,
       CONTACT_FIRST_NAME=:P14_FIRST_NAME,
       CONTACT_MIDDLE_INITIAL=:P14_MIDDLE_INITIAL,
       CONTACT_LAST_NAME=:P14_LAST_NAME,
       CONTACT_NAME_SUFFIX=:P14_SUFFIX,
       CONTACT_EMAIL_ADDRESS=:P14_EMAIL_ADDRESS,
       PRIMARY_PHONE=:P14_PRIMARY_PHONE,
       PRIMARY_PHONE_EXT=:P14_PRIMARY_EXT,
       OTHER_PHONE=:P14_OTHER_PHONE,
       OTHER_PHONE_EXT=:P14_OTHER_EXT,
       FAX_NO=:P14_FAX,
       WEBSITE_URL=:P14_WEBSITE_URL,
       WEB_ORG_TYPE=:P14_WEB_ORG_TYPE,
       LAST_UPDATED_BY=V('APP_USER'),
       PARENT_ORG_KEY=:P14_PARENT_ORG_KEY,
       SHORT_NAME=:P14_SHORT_NAME,
       CLASSIFICATION_KEY=:P14_CLASSIFICATION_KEY,
       STATE_KEY=:P14_STATE,
       SPECIALITY_KEY=:P14_SPECIALITY_KEY,
       BILL_ADDRESS_LINE_1=:P14_BILL_ADDRESS_LINE1,
       BILL_ADDRESS_LINE_2=:P14_BILL_ADDRESS_LINE_2,
       BILL_CITY=:P14_BILL_CITY,
       BILL_ZIP=:P14_BILL_ZIP,
       BILL_ZIP_PLUS_FOUR=:P14_BILL_ZIP_PLUS_FOUR,
       BILL_STATE_CD=:P14_BILL_STATE_CD,
       STATE_KEY_BILL=:P14_STATE_KEY_BILL,
       IS_LEGAL_ENTITY=:P14_IS_LEGAL_ENTITY
 where
      ORG_KEY=:P14_ORG_KEY
;
END;
{code}