title: How do I insert data into oracle's application express?
body: <p>I'm getting the error "ORA-00932: inconsistent datatypes: expected UDT got CHAR" when trying to insert data into my table through application express.</p>
  
  <p>My Table:</p>
  
  <pre><code>CREATE TABLE "TEST"."PERSONS" 
  (   "PERSON_ID" NUMBER, 
  "PERSON_NAME" VARCHAR2(50 BYTE), 
  "SURNAME" VARCHAR2(50 BYTE), 
   CONSTRAINT "PERSONS_PERSON_ID_PK" PRIMARY KEY ("PERSON_ID"));
  </code></pre>
  
  <p>When I try:</p>
  
  <pre><code>INSERT INTO PERSONS (PERSON_ID, PERSON_NAME, SURNAME)
  VALUES (8, 'Tony', 'Smith');
  </code></pre>
  
  <p>It works in sql devoloper but not application express. How can I resolve this?</p>