0

Hi all,
I m converting stored proc from sql server to oracle.
first have a look sql stored proc.
create procedure xyz..
as
begin
-- i have created one temp table
-- then inserted some data into it by select query over some db table.
-- then i have another temp table
-- then some recored gets inserted into second temp table by help of first temp table and some

3
Contributors
5
Replies
6
Views
9 Years
Discussion Span
Last Post by avtar.sohi
0

Hi all,
I m converting stored proc from sql server to oracle.
My application call these procedure and got datatable in case of sql server but now client want my applicaiton with oracle, so i m shifting my sql server db to oracle.
first have a look sql stored proc.
create procedure xyz..
as
begin
-- i have created one temp table
-- then inserted some data into it by select query over some db table.
-- then i have another temp table
-- then some recored gets inserted into second temp table by help of first temp table and some other table of db.
-- now finally it update second temp column data on some condition and then send back datatable to my soft. application
end;

what would be the approach to write this procedure in oracle.
please have a look over my oracle procedure which is not working.
create or replace procedure xyz...
as
begin
-- i have opened one cursor with select statement ( these select statement provide me all data which i m getting in second temp table)
-- now how can i update my cursor??????
end;

Thanks lot.
--

0

And what is your question?

PS: Just found you made double post, They been moved together.

my question was how to write that stored proc in oracle?

0

If you are familar with oracle procedures then you just need to take care of the syntax and just implement the logic in PLSQL.

0

i understand what was my mistake, i have to use global temp. table to handle this situation.
Tx lot .

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.