SQL Server Stored Procedure with # temp table conversion to Oracle
Posted on 2008-11-06
I have a SQL Server stored procedure which uses a TEMP table that I need to convert over to Oracle.
I know there is the GLOBAL TEMPORARY table that I can use in Oracle which takes care of the TEMP table. However, what I'm not too sure about is whether or not to use an Oracle FUNCTION or Oracle Stored Procedure. I only have to return back the value which was done with an OUT parameter in SQL Server.