Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
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 OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP 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
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
 
jQuery in Action, 2nd edition
 
subject: procedure in oracle