[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Macros Make Me Mad



>>>>> "Sundar" == Sundar Narasimhan <sundar@ascent.com> writes:

Sundar> Thanks Neel. I agree that the integration of SQL w/ the language
Sundar> datatype *is* the big win (and loss) w/ PL/SQL. 

Unfortunately, the integration in this specific case is surprisingly
bad, because you can't abstract over many entities of the sublanguage,
i.e. tables or the names of fields, which in practice leads to the
worst rashes of code duplication I've ever seen (at least when used in
industry).  You can essentially only stick verbatim SQL code in your
PL/SQL program.

There is "dynamic SQL" in PL/SQL but that means you have to assemble
strings containing SQL code which is just as bad as most other SQL
bindings for high-level languages.

-- 
Cheers =8-} Mike
Friede, Völkerverständigung und überhaupt blabla