This content has been marked as final. Show 4 replies
Hi,1 person found this helpful
A SQL*Server stored procedure can be converted to an Oracle function depending on how it is written and what it is doing. In the documentation -
Oracle® SQL Developer
Supplementary Information for Microsoft SQL Server and
Sybase Adaptive Server Migrations
In Chapter 3 in the section -
It says under Table 3-6 -
In Microsoft SQL Server or Sybase
Adaptive Server, you can convert a stored
procedure to a function in Oracle because
the stored procedure in Microsoft SQL
Server or Sybase Adaptive Server can
RETURN an integer value to the calling
routine using a RETURN statement. A
stored procedure returns a status value to
the calling routine even in the absence of
a RETURN statement. The returned status
is equal to ZERO if the procedure
execution is successful or NON-ZERO if
the procedure fails for some reason. The
RETURN statement can return only
And what tables do you see in oracle that are not there in SQL*Server ? Some tables are created as part of the migration as they are needed to have the same functionality as in SQL*Server.
Does your migrated Oracle database work in the same way as the SQL*Server database ? If not, then please give use specific examples and we can follow up.
If the table names begins with TT then those are temporary tables in oracle (global temporary tables) which is normal.1 person found this helpful
Thanks a lot Mike for the information.
About the tables, these are temporary tables used in SQL Server procedures are converted into Globala temporary tables in Oracle.
Yes, I found that the tables are being converted as temporary tables.