Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Stored procedures from SQL Server
I have PO7 for Windows NT up and working, and the ODBC drivers
installed. I think
everything is working somewhat. I am trying to port a SQL Server 6.5
database over to Oracle for testing, and I have this problem :
This is a stored procedure in SQL Server, and when I try to move this to
Oracle it fails. Questions.
1) Can I do this in oracle? (return a set of data from a stored
procedure)
2) if so, how?
3) if not why?
CREATE PROCEDURE Allocated_Time_All_For_Date(CC IN varchar2, ID IN
varchar2, TD IN varchar2)
AS
SELECT * from Allocated_Time WHERE
company_code = CC AND
employee_or_equipment_id = ID AND
timesheet_date = TD
ORDER BY rate_user_hours;
Any assistance would be appreciated. Received on Wed Mar 11 1998 - 00:00:00 CST