| 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
Donald,
My assumption about #2 was that they would abandon all the stored procs & packs that have been developed. That, to me, implies that they would also create Java objects to perform sql without using bind variables. My experience is that Java programmers do not want to learn about bind variables - indeed - the Java programmers I see here *barely* know how to right (sp???) decent sql. They don't have the experience or time to learn how to do it right.
Just me pessimistic view of things.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From: Freeman, Donald [mailto:dofreeman_at_state.pa.us]
Sent: Thursday, June 03, 2004 10:37 AM
To: oracle-l_at_freelists.org
Subject: RE: Database programming standards
1 and 3 I understand. I'm missing something about number 2. If they code their application, using bind variables, why will there be a sql-reuse issue? I would expect that cursors would be shared etc.. And to be fair they haven't said they want to move all of it but I'm not sure what criteria they would use to move which functionality. I kind of expect that they will be forced to learn pl/sql.
> 1). It will cost them time and money to move all of the
> logic to their application now.
> 2). Long term, you will guarantee that response-time of the
> application will slow because of the sql-reuse issue.
> 3). It is stupid idea to now change the implementation plan.
-- 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:58:27 CDT
 |
 |