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?