I've got a small form to add data to lists for when people want to add them (not using Interactive grid because it's fairly long at this point).
The dynamic action runs an Execute PL/SQL Code, submits three items (the three values) and returns one item (the response).
However, whenever I test it, it brings up:
"
Ajax call returned server error: ORA-20876: Stop APEX Engine For Execute PL/SQL Code
" as an error?
Here's the PL/SQL I'm using:
DECLARE
v_count NUMBER(10);
BEGIN
SELECT COUNT(*) INTO v_count
FROM TBL_REF_LIST_1
where LIST_CODE = :P7_LIST_CODE
OR LIST_DESC = :P7_LIST_DESC
OR LIST_CATEGORY = :P7_LIST_CATEGORY;
IF v_count > 0 THEN
:P7_RESPONSE_VALUE := 'List Item exists with one or more of the listed criteria';
ELSE
Insert INTO TBL_REF_LIST_1
(LIST_CODE, LIST_DESC, LIST_CATEGORY, ACTIVE)
VALUES
(:P7_LIST_CODE, :P7_LIST_DESC, :P7_LIST_CATEGORY, 1);
:P7_RESPONSE_VALUE0 := 'List Item loaded';
END IF;
END;What's wrong with what I've got here? Is it a permissions thing?