Re: Embedded SQL vs. PL/SQL (DB2 Embedded SQL vs. Oracle PL/SQL) (1/1)

In article <366BE8BA.571B8465_at_psu.edu>, planphier_at_psu.edu (Patrick Lanphier) wrote:

> If you have written Oracle PL/SQL and DB2 Embedded SQL in C, C++ or Java
> it would be great if you could please comment on development approaches,
> speed of development etc. It would be truly
> appreciated.
>
> Thank you for you time,
> Patrick Lanphier
> Advanced Information Technologies
> The Pennsylvania State University

I've used Oracle extensively over the last 4 years for one major project at work. At the beginning we were transferring millions of legacy data to the new system and handling large numbers of exceptions to standard rules, so at the beginning we went for the C approach for efficiency. I've attached a document (in Word 97 format) explaining why I pushed for OCI rather than Pro C.

The project is now up and running and wwe have different aims now that all of the legacy data is dealt with, and we will (long-term) switch over to PL-SQL for pure ease of maintenance. I think that if all of the features which are now available in the current versions of PL-SQL were available when we started the project, we would have seriously considered not using C. However, debugging PL/SQL is still not as easy as debugging C in integrated development environments!

Hope this is useful .... Dave Lane (dlane_at_pt.lu)