Converting SQL Server to Oracle

[Jevon]

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,

[Alex Ivascu]

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" <je**********@hotmail.com> wrote in message
news:34**************************@posting.google.c om...

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,

[Dave]

je**********@hotmail.com (Jevon) wrote in message news:<34**************************@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,

I don't know T-SQL that well, but maybe I can help.

What does [CrossTab - Bench Sheet] mean? It it returning results of
the query as a crosstab or something? Does it return a cursor to the
caller?

Can you show us what the Benchsheet table looks like and an example of
what the output is supposed to look like?

Dave

[Dave]

da**********@yahoo.com (Dave) wrote in message news:<5e**************************@posting.google. com>...

je**********@hotmail.com (Jevon) wrote in message news:<34**************************@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,

I don't know T-SQL that well, but maybe I can help.

What does [CrossTab - Bench Sheet] mean? It it returning results of
the query as a crosstab or something? Does it return a cursor to the
caller?

Can you show us what the Benchsheet table looks like and an example of
what the output is supposed to look like?

Dave

Sorry, stupid question. That's the name of the procedure. I've been
too focused on Oracle syntax lately. :~)