we did it on a non-java project. Steven developed a product, PL/Vision, which helps you to do this.
anything that doesn't clog my shared pool is a good thing :) --- Kimberly Smith <[EMAIL PROTECTED]> wrote: > I heard of it done on non-java projects. Steve Feuerstein (O'Reilly > author) > is/was pretty big on it if I remember. What is does is provide > consistent > access to your SQL. When you consider the way the cost based > optimizer > works > and the fact that the slightest difference in spacing or whatever in > a SQL > statement > will not allow reuse, not to mention all those developers who code > their own > way, some using bind variables and some not, it actually seems quite > beneficial. > > That being said, I have never done it. The closest I have come is > making > developers > remove the half a million identical statements from their stored code > and > making > a procedure out of it. > > -----Original Message----- > [EMAIL PROTECTED] > Sent: Tuesday, January 15, 2002 5:25 AM > To: Multiple recipients of list ORACLE-L > > > I've seen this done also on a Java project. My understanding was > that it > had to do more with the way an object oriented programmer's mind > worked > than with any code efficiency. > > > > > "Grabowy, > Chris" To: Multiple recipients > of list > ORACLE-L > <cgrabowy <[EMAIL PROTECTED]> > @fcg.com> cc: > Sent by: root Subject: Using > procedures > instead of coding > update/insert SQL...huh? > > 01/14/2002 > 10:10 AM > Please > respond to > ORACLE-L > > > > > > > I just joined a new Oracle/Java project using Tomcat app server. On > this > project they decided to create an update procedure and insert > procedure for > every table. This procedure is then called in the Java code with the > appropriate parameters passed, instead of simply coding the UPDATE or > INSERT > SQL directly in Java. > > Does anyone else take this approach? I'm trying to understand the > pros vs > cons of this approach. > > TIA!!! > > Chris > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Grabowy, Chris > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing > Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing > Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Kimberly Smith > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing > Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __________________________________________________ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
