Stored procedure for update query

Automation Studio
1

Hi,

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.

image

image

image

2

Hi,

Please help to suggest solution for this. Output field is greyed out, not able to select output table argument hence Execute database activity is giving error as below -

image