Hi,
i am trying to create a post api that insert into a table.
this is the code of the api:
begin
insert into HRemp(employee_number,full_name) values (122333,:NAME);
commit;
:response :='Done';
end;
API parameters:

and i am defining the rest data source in the shared components.
the row is being inserted but the value :NAME is inserted as null.
i have defined it in the data profile of the rest data source :

and also in the parameters of the operation :

i am new to this so how can i properly define the api or what is my error ?