Using sync editor to call stored procedure in target system

Hello Experts,

Is it possible to configure a SQL or Oracle connector to call a stored procedure in the target system to do CRUD operations?

We don't have access to the target system tables directly, instead we have been given a stored procedure which will return the values we need. How can we invoke this and do a column mapping?

Thanks

Kin