No. The PS3 version of The Elder Scrolls IV: Oblivion does not support mods. Sony's closed architecture and lack of official modding tools prevent it.
If modding is a priority, PC is the only platform for Oblivion (and Skyrim, Fallout 4, etc.).