Return table from function

I'm a MS SQL Server developer, but have an Oracle project I'm working on now. I have a function in MS SQL Server that I need to translate to Oracle using PL/SQL Developer. How can I do this in Oracle? Thanks!

I'm using:

INSERT INTO [TABLE]
SELECT * FROM dbo.[FUNCTION]

Where [FUNCTION] is defined as:

CREATE FUNCTION [FUNCTION](... DECLARE INPUT VARIABLES ...) RETURNS @TEMP_DTE TABLE
 (
  ... DECLARE TABLE FIELDS ...
 )
AS
BEGIN
 ...DO SOME STUFF...
 INSERT INTO @TEMP_DTE VALUES (...VALUES...)  RETURN
END Received on Fri Apr 13 2007 - 11:17:23 CDT