Using CCBPM

I have a scenario where I have to execute a stored procedure , then a sql statement and again a stored procedure to get the data out of a oracle db.After that it needs to be mapped to an idoc. Can it be done without CCBPM? The stored procedure is basically used to lock the rows till i am exceuting the sql statement and unlock it after i have executed sql.