can we perform DML operation in outsystem

can we perform DML operation in outsystem

  
hi

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:https://www.youtube.com/watch?v=ULsSP7WfZg0


Thanks in advance
Hi,

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.