prblm while converting sql server stored proc to oracle stored proc

[avtar.sohi]

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

[avtar.sohi]

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.
--

[peter_budo]

And what is your question?

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

[avtar.sohi]

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?

[debasisdas]

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

[avtar.sohi]

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