Re: procedural programming

SQL-Programmer 2.0 is for just that, server side programming! Stored Procedure, Functions, Triggers... Works also with SYBASE and MICROSOFT SQL Servers, all platforms Call SFI at 819 778-5045 ext:152 for details.

John Meyer,
Sylvain Faust Inc. (SFI)
http://www.sfi-software.com
Sylvain Faust Inc. Makes Tools for the Database Server Specialist since 1989
ORACLE World Alliance Partner
SYBASE Synergy Partner
MICROSOFT Solution Provider

Fabio Ferrari <fferrari_at_mail.enjoy.it> wrote in article <01bbb621$44b96f80$1e9078c3_at_fabio>...
> Chuck Hamilton <chuckh_at_dvol.com> wrote in article
> <325a8239.9414199_at_n5.gbso.net>...
> > What's the best way to do procedural structured programming for an
> > oracle database? PL/SQL with dynamic cursors, or PRO*C? What're the
> > main advantags?
>
> PL/SQL:
> need no C or C++ compilers
> code is executed server-side (may be faster)
> isn't general purpose
> link to O.S. isn't so good
> writing SQL statements is easier
> the user interface is poor
> is O.S. indipendent
>
> PRO*C:
> you need a C compiler for the client O.S. and the Oracle PRO*C
> preprocessor.
> C is general purpose
> C is open to many O.S.
> there are mountains of code and libraries written with C
>
> Someone else will find additional features.
>
> Usually i prefer PL/SQL when there is no interaction with an O.S., the
 user
> or other C code.
>
> Good work and Bye.
>
>
> P.S. Please mail me your choice and reasons, thanks.
>
> Fabio Ferrari
> GeDInfo scrl
> fferrari_at_mail.enjoy.it
>
Received on Sat Oct 12 1996 - 00:00:00 CEST