From: alexdivascu@hotmail.com   
      
   What's the purpose?  To return the values?  Then you might want to create a   
   function that returns the table...   
      
   here's the proc version....   
      
   create procedure CrossTab_BenchSheet (vi_bsid number)   
   as   
   begin   
       select    *   
       from    BenchSheets   
       where  bsid = vi_bsid;   
   end;   
   /   
      
      
   "Jevon"  wrote in message   
   news:34e7f100.0404071038.211932f5@posting.google.com...   
   > 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]   
   > @BSID Int   
   > AS   
   > SELECT BenchSheets.*   
   > FROM BenchSheets   
   > WHERE BS_ID=@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,   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)