By checking the queries available in forum, I understand that we can’t use update query directly. We need to create stored procedure.
I have created a stored procedure and also added input/output parameter but Output filed is greyed out as shown in below screenshot. UpdateStoredProcedure is the argument defined in studio and assigned procedure name to it.
The created procedure is working fine in SQL developer and has only one input.