Hi Riya,
If it is written in PL/SQL,
you should not have any problems in executing the same in Oracle.I donot think you need to write the code once again for Oracle.
I will check up with my colleagues, if there is any difference between the PL/SQL coded for SQL Server and Oracle.If there is, then I will also try to find a tool which can perform this conversion.However, to the best of my knowledge, it should not be required.
Regards,
Sandeep