can we perform DML operation in outsystem


i am trying to delete record from existing database (integrate from oracle) using advance sql control but it was not deleted from database.
My question is : can we delete record from existing database using advance sql control in service studio.
Note: i am selecting data from same database and its working fine. i have integrate oracle database using integration studio and use created entity in service studio. while fetching its working fine but in case of deletion its not delete record from actual database.

I refer these video:

Thanks in advance

Any error logged?
I guess that the user that connect to the DB, probably doesn't have permissions to delete records from the table.

hi nuno,

thanks for your reply.

where we find the error log?
Try check in the Service Center, in the Monitoring menu, you have two submenus, Error and General.