How do I insert data into oracle's application express?

504 Views Asked by At

I'm getting the error "ORA-00932: inconsistent datatypes: expected UDT got CHAR" when trying to insert data into my table through application express.

My Table:

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"));

When I try:

INSERT INTO PERSONS (PERSON_ID, PERSON_NAME, SURNAME)
VALUES (8, 'Tony', 'Smith');

It works in sql devoloper but not application express. How can I resolve this?

0

There are 0 best solutions below