470,815 Members | 1,284 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,815 developers. It's quick & easy.

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]
@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
3 3918
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
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
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.

Similar topics

1 post views Thread by Mike Landis | last post: by
1 post views Thread by Ixnay | last post: by
3 posts views Thread by Jevon | last post: by
4 posts views Thread by --CELKO-- | last post: by
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.