Hi,
Is there any error you are receiving while extracting data form the output data table. if you face any errors please share us with the screenshot.
And also please make sure that you have enabled the Command type as stored procedure in the dropdown to enable ability for the execute query activity to execute stored procedures.
Usually execute Query enabled with stored procedure will provide the output as data table.
once you get the datatable you could get the ORDERID by using following expression YourOutputDT.Rows(0).Item(“ORDERID”).ToString
I could see that you assigned NULL value for the ORDERID for testing are you going to enter any order number. thanks.
Please refer the below threads for more guidance. thanks.