Re: Pro*C vs SQLPlus script??

HI,

I'd say that portablity is a good reason to choose for a PL/SQL BLOCK to handle your tasks.

Just put if over and it works.

For POR*C you have to look at ANSI-C vs other .....

On the other hand I find writing sample reports with dbms_output a pain in the ass, while C (alltough far from great) has more potential, espescially if you want to have

warning and errors and output written to your screen and/or several files.

Danny
gcherer_at_millenium.texas.net (GT Cherer) wrote:
>
>Dudes-
>Other than the obvious cases - complex manipulation, when'ing, etc -
>what criteria does one use to weigh short-n-swift Pro*C programs vs
>quick-n-simple SQLPlus unix scripts when the case is something like drop
>all keys, or create indexes, or a fairly trivial cursor???? you know,
>when the issue is not writing the code itself. What do you look at?? time,
>of course, but what and where do other issues play in the mix like
>security, maintainability, login/password hiding, etc??
>
>I am sure this question hits us all sometime, so what's yer 2-pennies
>worth on how you flipped the coin?? thanxabunch
Received on Wed Sep 11 1996 - 00:00:00 CEST