Updating Data Using RESTful Service

 Updating Data Using RESTful Service

In this section, you will create a RESTful Service to update data using the HTTP Method PUT.

 You will use the postman tool to test your RESTful Service, 

and to verify the results

Specify the PUT Method and Source Type as PL/SQL. 

Provide the Source Code for the PL/SQL

BEGIN

UPDATE EMP  

Set  SAL = SAL*2 

WHERE EMPNO= :empid;

htp.prn('Updated');

END;

Test in Postman, select PUT, enter the correct URL adding /124, click the Body tab,

 check raw, 

 Click Send.If the update was successful, you will see the message below.