How to use UPSERT in Actuate birt to modify the Database using prompts
I am trying to call the sql function which contains the 'UPSERT' which means - "if given input exits then do Update else Insert". This is because I have a request that using the prompt values we have to update the Database using BIRT report.
At present I am getting issue with 'UPSERT' I am failing with this concept. Could anyone of you please tell me how to write the Logic code for Upsert in pgplsql. So then I can call the database and update the database using the birt report parameter values. Thanks in advance.