Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

procedure in oracle

 
riya chacko
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello all,
I have some 60 sql stored procedure.I want to write the same stored procedure in oracle.Can u give me any links related to this or what is the difference b/w these two.It is very urgent.Thanks in advance.
Expecting ur replys
 
Desai Sandeep
Ranch Hand
Posts: 1157
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Riya,
Could you clarify where/or in what 60 SQL Stored Procedures are coded.Is it coded in PL/SQL.If that is the case, what is the requirement.
Regards,
Sandeep
 
riya chacko
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi SANDEEP,
It is coded in PL\SQL and it is written in sql server.
Regards
Riya

 
Desai Sandeep
Ranch Hand
Posts: 1157
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Riya,
If it is written in PL/SQL, you should not have any problems in executing the same in Oracle.I donot think you need to write the code once again for Oracle.
I will check up with my colleagues, if there is any difference between the PL/SQL coded for SQL Server and Oracle.If there is, then I will also try to find a tool which can perform this conversion.However, to the best of my knowledge, it should not be required.
Regards,
Sandeep
 
riya chacko
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sir,
What I understood is that the sql will return a resultset where as oracle won't.So when I am writing the same pl/sql code in oracle I have to do the necessary modifications to retrieve a resultset.
one person told me that it is not possible to retrieve a resultset through a storedprocedure,for that I have to write a function it seems and I have to use reference cursor.Is it right?
Regards
Riya
 
riya chacko
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sir,
What I understood is that the sql will return a resultset where as oracle won't.So when I am writing the same pl/sql code in oracle I have to do the necessary modifications to retrieve a resultset.
one person told me that it is not possible to retrieve a resultset through a storedprocedure,for that I have to write a function it seems and I have to use reference cursor.Is it right?
Regards
Riya
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic