Re: Pro*C vs. PL/SQL

Kevin Merritt wrote:
>
> I would like anybody's thoughts on the advantages and/or
> disadvantages of developing robust applications in PRO*C
> vs. PL/SQL.
>
> We are porting a mature, robust COBOL application to Oracle
> and would like to choose the right long-term development
> tool.
>
> Specifically, I'd like feedback comparing PRO*C with PL/SQL
> on the following areas:
>
> Performance
> Learning Curve
> Long Term Maintainability
> Time of Development
>
> For purposes of this comparison, assume that our staff is
> comprised of strong C programmers who have no knowledge of
> either PRO*C or PL/SQL.
>
> I appreciate your feedback in advance.
>
> Kevin Merritt

To my experience in Pro*C and PL/SQL, my opinion is that there is no point of using Pro*C if PL/SQL works.

Because if you use PL/SQL, you will get
1. Surely better performance. Because all the function is performed on server. So less comm. overhead.
2. MUCH Easy to learn. You know SQL, you know PL/SQL. But you C, you know nothing about Pro*C. 3. MUCH Easy to debug/compile/maintain. Only affected PL/SQL procedure need to be update. But Pro*C, compiling one program but may linking many. 4. Pro*C 3x longer development time AT LEAST.

Don't use Pro*C unless you have VERY special reason. Received on Thu Jan 18 1996 - 00:00:00 CET