Re: Converting SQL Server to Oracle

From: Alex Ivascu <alexdivascu_at_hotmail.com>
Date: Wed, 7 Apr 2004 13:53:37 -0700
Message-ID: <XSZcc.104$Pw1.90_at_fed1read05>


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" <jevonthurlow_at_hotmail.com> wrote in message news:34e7f100.0404071038.211932f5_at_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]
> _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 - 22:53:37 CEST

Original text of this message