Re: Do APEX-installed packages include business logic?
Date: Sat, 29 Aug 2009 21:16:15 -0400
> Is it PL/SQL based only when the developer uses the wizards?
No, it's all PL/SQL based. It's built on top of the web PL/SQL toolkit. If you install it, export the sample application that is automatically created. You'll see it's 100% SQL/PL/SQL.
If they don't use them, is the benefit of APEX (rapid development) lost?
No, absolutely not. I've used as little of the built-in stuff (wizards) as possible and the RAD aspect remains. Perhaps that's a remnant of my former J2EE days (using stored procs for *everything*). If you have an existing application that uses packages, there are forms you can automatically generate based on the signature of those stored procs. You'll have to fine-tune them, but it still beats any other platform (that I have seen) in terms of speed of development.
(If you can't tell, I'm kind of a fan).
-- chet justice www.oraclenerd.com On Sat, Aug 29, 2009 at 3:02 PM, Yong Huang <yong321_at_yahoo.com> wrote:Received on Sat Aug 29 2009 - 20:16:15 CDT
> > APEX is PL/SQL based.
> > You "might" encounter some business
> > rule problems if you use the
> > wizards to generate the data entry screens for you.
> > ...
> > If your team develops all of
> > the data entry screens manually (instead of using the
> > wizards), then chances are that you will never have
> > a problem with Apex.
> Thanks, Chet and Bill. If APEX is PL/SQL based, I guess it must have
> lots of packages even a PL/SQL expert has to spend hours of time
> troubleshooting (unless he knows APEX and business). Is it PL/SQL
> based only when the developer uses the wizards? Can DBAs technically
> prevent them from using the wizards? If they don't use them, is the
> benefit of APEX (rapid development) lost?
> Yong Huang