By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,195 Members | 954 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,195 IT Pros & Developers. It's quick & easy.

Converting SQL Server to Oracle

P: n/a
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,
Jul 19 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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,

Jul 19 '05 #2

P: n/a
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
Jul 19 '05 #3

P: n/a
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. :~)
Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.