Re: Oracle Stored Procedures VERSUS SQL Server Stored Procedures

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Thu, 7 Jul 2005 20:48:29 -0700
Message-ID: <PJedncQwzunSalDfRVn-iQ@comcast.com>

<jrefactors_at_hotmail.com> wrote in message news:1120793932.351921.5760_at_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 Received on Thu Jul 07 2005 - 22:48:29 CDT