Posted by Jim Kennedy on 07/08/05 06:48

<jrefactors@hotmail.com> wrote in message
news:1120793932.351921.5760@g43g2000cwa.googlegroups.com...
> I want to know the differences between SQL Server 2000 stored
> procedures and oracle stored procedures? Do they have different
> syntax? The concept should be the same that the stored procedures
> execute in the database server with better performance?
>
> Please advise good references for Oracle stored procedures also.
>
> thanks!!
>
SQL Server Stored procedures use transact sql and run on SQL Server
Oracle Stored Procedures use pl/sql (modeled on ADA) and run on Oracle.

Oracle!=SQL Server

They use two very different concurrent models and the syntax is totally
different.
(eg you don't need to create temp tables in Oracle like in SQL Server)
otn.oracle.com and look under documentation.
Jim

[Back to original message]