File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Oracle/OAS and the fly likes procedure in oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "procedure in oracle" Watch "procedure in oracle" New topic
Author

procedure in oracle

riya chacko
Greenhorn

Joined: Oct 20, 2001
Posts: 7
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
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
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
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
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
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: procedure in oracle