Hi @arjun27 ,
I have tested your situation to my side . I identified that have to change the command type is to “storedprocedure”. If i set it as “Text”, Yes I am getting error what you have specified in the above.
Below i have attached the screen and my sample files also.
In the sample file , It has Execute query and Execute Non Query (Both)
File : Update Database.zip (2.6 KB)
Regards
Balamurugan.S