enter

DECLARE
vCount  NUMBER;
v_dname VARCHAR2(100);
v_loc   VARCHAR2(100);
v_json CLOB;

BEGIN

v_json := :BODY;
APEX_JSON.parse(v_json);
vCount := APEX_JSON.get_count(p_path => 'dept');

htp.prn('data count-'||vCount);

IF vCount > 0 THEN
    FOR i IN 1 .. vCount LOOP
        v_dname := apex_json.get_varchar2(p_path => 'dept[%d].dname', p0 => i);
        v_loc   := apex_json.get_varchar2(p_path => 'dept[%d].loc', p0 => i);

       INSERT INTO dept (DNAME, LOC)  
       VALUES (v_dname, v_loc);
    END LOOP;
    COMMIT;  
END IF;
end;

here

and JSON Data is:

{
  "dept": [
    {
     "dname": "IT",
     "loc": "DHAKA"
    },
   {
     "dname": "HR",
     "loc": "CHITTAGONG"
    },
   {
     "dname": "FINANCE",
     "loc": "KHULNA"
   }
  ]
 }

primary key deptno is created with a trigger.

Now every time I call the api from the postman I get the following error.

The request could not be processed because an error occurred whilst attempting to evaluate a SQL statement associated with this resource. Verify that the URI and payload are correctly specified for the requested operation. If the issue persists then please contact the author of the resource. SQL Error Code: 6550, Error Message: ORA-06550: line 8, column 11: PLS-00382: expression is of wrong type ORA-06550: line 8, column 1: PL/SQL: Statement ignored /