Home » SQL & PL/SQL » Client Tools » how to convert SQL server stored procedures to Oracle 11g (Oracle 11g)
how to convert SQL server stored procedures to Oracle 11g [message #594788] Tue, 03 September 2013 03:02 Go to next message
ramya_162
Messages: 96
Registered: August 2013
Location: Banglore
Member
Hi Experts,

In SQL server 30 stored procedures are there how to convert all the stored procedure
from SQL server to Oracle 11g.

Please help me,

Thanks.
Re: how to convert SQL server stored procedures to Oracle 11g [message #594789 is a reply to message #594788] Tue, 03 September 2013 03:33 Go to previous messageGo to next message
Michel Cadot
Messages: 58609
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you want to convert the code, there is no problem, many tools can do it.
But migrating code from SQL Server to Oracle does not just mean convert code, it means rewrite it as the transactional models are different.

Regards
Michel
Re: how to convert SQL server stored procedures to Oracle 11g [message #594795 is a reply to message #594789] Tue, 03 September 2013 04:42 Go to previous messageGo to next message
ramya_162
Messages: 96
Registered: August 2013
Location: Banglore
Member
Hi,

I want to convert the SQL server code to Oracle code with oracle syntax
with the same functionality.

Please name one tool which good and easiest.

Thanks.
Re: how to convert SQL server stored procedures to Oracle 11g [message #594798 is a reply to message #594795] Tue, 03 September 2013 04:46 Go to previous messageGo to next message
Michel Cadot
Messages: 58609
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please just Google.

Regards
Michel
Re: how to convert SQL server stored procedures to Oracle 11g [message #594856 is a reply to message #594788] Tue, 03 September 2013 09:29 Go to previous message
thatjeffsmith
Messages: 35
Registered: July 2009
Location: Raleigh, NC
Member

Oracle SQL Developer's migration projects will be able to help you a bit. Really the nature of the problem comes down to what your stored procs are doing. Many T-SQL procs are just queries with the data coming back.

To get that working in Oracle will require you to rewrite them such to use explicit cursors and change the procedure arguments to include an out params or return values.

However, that's changed a bit for Oracle Database 12c - for the better.

Previous Topic: SQLPLUS for Oracle 11 not rolling back
Next Topic: display windows on OracleSQL Developer
Goto Forum:
  


Current Time: Tue Jul 29 07:57:08 CDT 2014

Total time taken to generate the page: 0.08211 seconds