Hi,

What you are trying to do with last line of sql query. First 2 lines are update statement. But didn't getting the purpose of last line.

regards

hi,

Please add semicolon ";" after the UPDATE statement and then SELECT statement.

As oracle uses semicolon ";" to identify each statement when multiple statement given.

Please check;

Hope it will help.

Hi Kumar Chandrasekaran, 

You can separate in two sql advance query, the first one for the update the output should be an integer. 

For the select, just need  the consultantclarificationId as input and use as output the record as you have in the image. 

Hope that it helps you 

Hi Kumar Chandrasekaran, 

Check out here this forge component for samples 

https://www.outsystems.com/forge/component-overview/10200/sql-advanced-query-samples-for-dummies

Hope that it helps you 

Hi Kumar,

As I can see the error code and error, it is clear that something is wrong with query. Your query looks ok and issue should be with your data. So I would suggest

1. First only try update query and set hard-coded values only. 

2. If it works then test update query with only one at a time input value to identify which data is responsible for error. 

Keep posting here for more help.

Best of luck.