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
Joined: Apr 02, 2001
Posts: 1157
posted
0
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
<b>Sandeep</b> <br /> <br /><b>Sun Certified Programmer for Java 2 Platform</b><br /> <br /><b>Oracle Certified Solution Developer - JDeveloper</b><br /><b>-- Oracle JDeveloper Rel. 3.0 - Develop Database Applications with Java </b><br /><b>-- Object-Oriented Analysis and Design with UML</b><br /> <br /><b>Oracle Certified Enterprise Developer - Oracle Internet Platform</b><br /><b>-- Enterprise Connectivity with J2EE </b><br /><b>-- Enterprise Development on the Oracle Internet Platform </b>
riya chacko
Greenhorn
Joined: Oct 20, 2001
Posts: 7
posted
0
Hi SANDEEP, It is coded in PL\SQL and it is written in sql server. Regards Riya
Desai Sandeep
Ranch Hand
Joined: Apr 02, 2001
Posts: 1157
posted
0
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
Joined: Oct 20, 2001
Posts: 7
posted
0
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
Joined: Oct 20, 2001
Posts: 7
posted
0
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
0
