Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Creating a Post Api in Oracle Apex24

Charbel Eid3 days ago

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 ?

Comments
Post Details
Added 3 days ago
2 comments
37 views