Why do you want 1 transaction for 3 different tables?
If all 3 tables has no primary/foreign key between them, so actually they can be in separates transactions. Stored procedure is possible depending on your business logic.
If one table has an error do you want to continue with other 2 or cancel all the three?
If it's possible, try to add field in each table so they will be connected by foreign key - that way you will be able to connect between them.