Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Do you use PL/SQL

Re: Do you use PL/SQL

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 24 May 2007 13:04:43 -0700
Message-ID: <1180037083.246314@bubbleator.drizzle.com>


hasta_l3_at_hotmail.com wrote:
> On 24 mai, 17:51, DA Morgan <damor..._at_psoug.org> wrote:

>> hasta..._at_hotmail.com wrote:
>> Not if done properly?
>>
>> Consider that Oracle supports this very same database on multiple
>> versions of Windows, Linux, Solaris, HP/UX, AIX, etc. And they do
>> it with essentially one code base while taking advantage of those
>> aspects of each that are product specific.

>
> Getting your point a bit late...
>
> 1. I would hold that oracle does not actually use Windows
> to it fullest (notably in the user interface area)
>
> 2. Even when ignoring the incompatibility of SP languages,
> I dont see how to build a tiny compatibility layer. If a bulk
> collect is fast for database A, and a loop is fast for database
> B, well, you have to rewrite all looping code. You cannot really
> abstract a loop (in standard procedural languages)
>
> --- Raoul

Of course you have to. You have to anyway once you get past simple DML statements. But if you put your code into procedures everything that passes parameters can be written once.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu May 24 2007 - 15:04:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US