It is very urgent so please help me out in finding the solution for it.
As I have the below given procedure and its working fine but my requirement is, if same odl_id is coming and status is running then it should update the starttime and if same odl_id and status is stoped then it should update stopetime and if new odl_id ,then it should insert new row.
How to do it please help me as the scenario is as following:
create or replace PROCEDURE SP_SaveUserTransactions
ODLID IN Varchar2,
Statuss IN varchar2,
INSERT INTO CAPS_ODL_TRANSACTION