Help! PL/SQL Stored Procedures

[Quoted] Hi all,

I need to migrate a MS SQL Server database to an Oracle7 database. I'm worried about the migration of my T-SQL stored procedures. Should I rewrite all my procedures ?
And does it affect the way of sending data to the Client ?

So a few questions about PL/SQL stored procedures :

• Does PL/SQL stored procedures support input and output variables ? [Quoted]
• Can PL/SQL stored procedures return a result set with multiple rows ? And how ? [Quoted]
• Can PL/SQL stored procedures return multiple different results ? And how ? [Quoted]
• Does it exist tools that can transform T-SQL procedures into PL/SQL procedures ? [Quoted]
• Does it exist documentation on this problem ?

Thanks in advance

--

A french DBA
Guillaume CHAPUS
gchapus_at_ifhamy.insa-lyon.fr