What are advantages of Pro*C?

[sbasak]

Is there any advantage of ProC over other alternatives? In which situation one should go for ProC (for application business logic) instead of SQLJ or VB.NET, because all of them basically do the same thing?

Any suggestions welcome.

Thanks

[jim mcnamara]

Pro*C provides the greatest throughput when run on a server.
It doesn't gain you anything running on a client.

If you are making a distributed app, where the code runs on the client, use VB or Oracle Forms for the PC apps, Pro*C or PL/SQL for server background support (for example, a server app that runs coninuously and scans periodically for open orders to process them almost as soon as they come in), reporting, etc.

Our system has 2500 users with 4 unix boxes for servers, and Oracle Forms running on PC clients.

[sbasak]

Well, assuming running on server, what will be better - Pro*C or PL/SQL? Undoubtedly coding in PL/SQL easier than Pro*C. So, what shall I gain using Pro*C instead of PL/SQL?

Thanks.

[jim mcnamara]

Unless you use Oracle 9i, Pro*C uses the standard SQL parser
(like you can use use new analytic functions, case statement, etc)
PL/SQL uses an older, separate parser. You cannot access those features in PL/SQL

In any event, Pro*C is faster, period.

Go here:

http://asktom.oracle.com/pls/ask/f?p=4950:1:

Or better --

Get Tom Kyte's 'expert one-on-one Oracle' book.