| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Database programming standards
Freeman,
Thanks for the info, but I do not understand why putting logic in a PL/SQL caused problem?? Can you please post couple of examples of the problems you faced?
The only reason I can think of, for you favoring .net code instead of PL/SQL is if you are having a lot of .net expertise in-house and very few PL/SQL programmers.
Thanks
Deen
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Freeman, Donald
Sent: Thursday, June 03, 2004 9:22 AM
To: oracle-l_at_freelists.org
Subject: RE: Database programming standards
We are undergoing this battle. The project that I am assigned to hired contractors who brought in pl/sql programmers and put 90% of the logic and business rules in the backend implemented as pl/sql. Now the project end is in sight and all the full-time staff programmers (hired more recently) are .net programmers who want to rip it all out and put it into the front end. Why? "Because the job will be much easier long-term after they are gone."<g>
> One standard that I would insist on is that *all* sql will be
> written in
> PL/SQL (stored packages, procedures and functions). The J2EE
> classes can
> simply call these objects to perform the sql operation. This
> solves all of
> the bind variable problems. Of course, this means that they will need
> oracle back-end specialists. But it will make your job much easier
> long-term after they are gone.
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Thu Jun 03 2004 - 09:14:18 CDT
 |
 |