Re: Do APEX-installed packages include business logic?

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.

In 2005, I built a 350 page application in 18 months, by myself. That, for me, is a huge point of pride and speaks volumes for APEX. If you have strong PL/SQL/database skills, it allows you to concentrate on the fundamentals of your application (i.e. data/data modeling) without having to worry (much) about the front end side. But don't let that fool you, APEX is infinitely flexible. You can do in APEX the same things you can do (Javascript, Ajax, etc) with any other language (Java/.NET/Ruby) but far easier.

(If you can't tell, I'm kind of a fan).

chet

-- 
chet justice
www.oraclenerd.com

On Sat, Aug 29, 2009 at 3:02 PM, Yong Huang <yong321_at_yahoo.com> wrote:



> > 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

>

>

>

>


--
http://www.freelists.org/webpage/oracle-l