Re: Do APEX-installed packages include business logic?
Date: Fri, 28 Aug 2009 16:28:16 -0400
You should not have to go through that much trouble (yikes) with APEX.
For each application, there is a report that allows you to compute all the database object dependencies. That report allows you to easily identify where a certain package call.
I have no experience with Designer, so I can't really compare...APEX is PL/SQL based. Errors thrown at the application level (if not caught by a developer's WHEN OTHERS) will bubble to the interface (web page).
I've typically used APEX as a presentation layer only, in other words, calling existing procedures/functions. You can however create things like multi-record table INSERTs using the tool (it was originally marketing as a Microsoft Access killer), but I've found that it's pretty easy to dig through. The "application" is just a SQL file that can be (if necessary) run from SQL*Plus, though it's typically loaded through the interface.
It's a very powerful and robust tool.
Hope this helps.
-- chet justice www.oraclenerd.com On Fri, Aug 28, 2009 at 3:41 PM, Yong Huang <yong321_at_yahoo.com> wrote:Received on Fri Aug 28 2009 - 15:28:16 CDT
> One of our clients is interested in using Oracle Application Express on
> our 10.2.0.4 database. We haven't installed it. There's a concern in our
> DBA team that the APEX installed packages could include business logic,
> much like Oracle Designer does. Our Designer application was written
> many years ago and nobody here knows that tool. When the app fails, DBAs
> have to inject utl_file.put_line in many places in the spaghetti code,
> starting from the package whose name is visible in the user's browser
> URL. In the past few years, we always succeeded in narrowing down to
> the exact package and line that broke, but it's a laborious process.
> Does APEX install packages that have site-specific procedures and logic
> as Designer does?
> Yong Huang