The community of Analytics developers are invited to follow and participate in the developer network.
OpenText technical experts collaborate with supported customers and partners in the Magellan product area.

How to use UPSERT in Actuate birt to modify the Database using prompts

Hello Team,

Good morning!

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.

Thanks & Regards,


  • I don't believe this question is related to BIRT. It is possible that you will get an answer here, but you would be better served posting it to the database forum.

    Jeff F.
    Sr. Technical Support Specialist
Sign In or Register to comment.