Converting SQL Server to Oracle

I am trying to conert a SQL Server (2000) database to Oracle to see if it is a supportable back end for my product. I am running into a stone wall with Stored Procedures though. I was wondering if someone could explain a simple way to turn this T-SQL statement into a Oracle PL/SQL statement:

CREATE PROCEDURE [CrossTab - Bench Sheet] _at_BSID Int
AS
SELECT BenchSheets.*
FROM BenchSheets
WHERE BS_ID=_at_BSID

I can't seem to find an easy way to do it and documentation isn't very helpful. If using a Stored Procedure is the wrong way I am open to any alternative to running a "Select" statement with a parameter to filter down.

I appreciate any input, Received on Wed Apr 07 2004 - 20:38:46 CEST