Re: What is PL/SQL?

From: James O. Payne, Jr. <james_at_sugaree.uu.net>
Date: 3 Apr 92 21:31:40 GMT
Message-ID: <1992Apr3.173140.153_at_sugaree.uu.net>


In article <1992Apr3.115047.9048_at_jyu.fi>, hkau_at_jyu.fi (Harri J Kaukovuo) writes:
> In article <1992Mar27.174137.5277_at_fmsrl7.srl.ford.com> hugh_at_slee06.srl.ford.com (Hugh Fader) writes:
> PL/SQL is part of SQL*Forms 3.0. You can use PL/SQL in procedures and
> triggers. Using PL/SQL is MUCH MORE convenient way to program than the
> SQL*Forms 2.x version triggers (steps etc.). I recomment!

PL/SQL is much more than just a part of SQL*Forms v3.0...it also replaces the PRO*yerfavelanghere interfaces. It seems to be a lot faster than PRO*Pascal (which is what we deal with here), apparently due to the fact that the ORACLE parser is only accessed once per block (a logical unit of PL/SQL code) rather than once per SQL statement (the way PRO*whosis is handled). The problem is that the package seems to be immature...the error handling is buggy (return code 1403 vs. return code 100) and you can't use SQL*Plus commands in a PL/SQL block (which I understand and can live with) or DDL statements either (which is a real drag).

I can't wait for the next major revision. Compared to writing a PRO*phlegm program, developing in PL/SQL is quick and easy...


| James O. Payne, Jr.                                                     |
| IKEA NA Information Systems                           215/834-0180 x343 |
 ===========================================================================
|          "It's a big country.  Someone's got to furnish it."            |
|     (IKEA is much too busy selling furniture to pay attention to my     |
|             drivel, let alone to be responsible for it.)                |
===========================================================================
Received on Fri Apr 03 1992 - 23:31:40 CEST

Original text of this message