Access to the db security model through the use of oracle users and roles.
You cannot do this with a cfquery.
Try working with a pl/sql array in a query block. or a clob. Or any kind of
advanced PL/SQL. What kind of work can you do with the OID? None.
These are oracle specific examples. But that's the environment in which I
work.
--
Timothy Heald
Web Portfolio Manager
Overseas Security Advisory Council
U.S. Department of State
571.345.2319
The opinions expressed here do not necessarily reflect those of the U.S.
Department of State or any affiliated organization(s). Nor have these
opinions been approved or sanctioned by these organizations. This e-mail is
unclassified based on the definitions in E.O. 12958.
-----Original Message-----
From: Matt Liotta [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 24, 2004 9:58 AM
To: CF-Talk
Subject: Re: why are procedures better? (was: RE: Securing CF Apps.)
> Yes, we are having a generic technical debate, and what I am saying is
> that
> when the team setup or hierarchical setup is not ideal, separating
> work out
> makes the project move along faster. Stored procs come into play here
> in
> that someone can tackle this aspect while other things are being
> taken care
> of.... That's pretty generic... Just another situation in which
> stored procs
> are better.
>
Maybe I wasn't clear in my reply to that statement. There is nothing
inherent about stored procedures which makes them better for separating
out work. It is in fact the same amount of work to separate queries as
it is stored procedures.
So far in this thread, the only benefit mentioned so far for stored
procedures is transaction handling.
-Matt
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
