Re: PL/SQL Limitations

In article <4er7r0$eqn_at_athos.cc.bellcore.com>, Parris Geiser <parris_at_walleye.esp.bellcore.com> wrote:
>Hi,
> In deciding on whether to PL/SQL or PRO*C I've come across
> a couple of PL/SQL limitations:
> 1. No exception is raised if there is a failure to allocate
> a next extent. The insert fails, but there is no indication.
> 2. A long field is limited to 32K.
>
> Are there other such limitations?

Of course. But there are also extensions.

They address different needs. PL/SQL is an interpreted solution, with procedures/functions stored in the RDBMS (yes, the RDBMS "compiles" the PL/SQL). PL/SQL also meshes nicely with other Oracle products such as Forms. PRO*C is more for people doing 3rd-generation programming (C/C++/X) who want a back-end RDBMS engine.

PL/SQL is an inside-out solution (RDBMS ---> procedural language). PRO*C is an outside-in solution (procedural language ---> RDBMS).

There is a very good Nutshell book on PL/SQL that just came out a few months back. About 1,000 pages...

-- 
==============================================================================
 Phil Perucci ......... pperucci_at_access.digex.net ........ Systems Integrator 
==============================================================================