Re: PL/SQL .vs. Pro*C

Previously you couldn't access files from PL/SQL and that is already a reason why people had to use either Pro*C or Pro*Cobol. At the company I work, we use Pro*C mainly for its processing power (we need to do very many transactions within an overnight batch) and for reporting and interfacing work. The interfacing part consists mostly of creating formatted flat files with data from Oracle. The reports we do are mostly large or needed in flat files so we use Pro*C instead of Reports 2.5. I think commercially it is still the better alternative although plsql has become quite mature lately.

Gerrit-Jan Linker
Oracle developer @ SCT international

http://members.aol.com/gjlinker

In article <6gtbfe$1jc$1_at_nnrp1.dejanews.com>,   MatthewLF_at_pobox.com wrote:
>
> Am wondering if anyone out there has had experience using both PL/SQL and
> Pro*C. Specifically, I'd like someone to explain to me why I would use
Pro*C
> to do something which could be done in PL/SQL. I have just been on a
project
> which used Pro*C with embedded SQL to do all Oracle operations. I did not
> write any of the code myself, but I have written scads of PL/SQL. I found
> myself looking at pages of Pro*C and thinking to myself that I could do it
> much easier in PL/SQL since it was 95% data manipulation. The only
argument I
> have heard so far is that Pro*C is faster than stored procedures/packages.
If
> this is the only argument I'd like some feedback on just how much faster it
is
> (all of our routines on this project are too small to do any benchmarking
> with). It seems to me that unless it is several times faster, the benefit
of
> execution time does not outway the nightmare of maintenance time.
>
> Thanks for any input.
>
> Matt.
> MatthewLF_at_pobox.com
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Apr 14 1998 - 09:24:56 CDT