yes ,you can do. if the oracle table hourly slot. in that case it will leads to dead lock. other than that you can proced and directly join with oracle table