Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Using procedures instead of coding update/insert SQL...huh?

RE: Using procedures instead of coding update/insert SQL...huh?

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Mon, 14 Jan 2002 09:01:14 -0800
Message-ID: <F001.003EF3E0.20020114082026@fatcity.com>


It makes absolute sense to use this encapsulated approach, because you don't have to keep changing your code for DML every time table structure changes, plus this way you guarantee that everyone will use the same statement promoting its reuse in the SGA.

Oracle designer likes to call this approach TAPI (Table API).

Raj



Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!

*********************************************************************2

This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.

*********************************************************************2
Received on Mon Jan 14 2002 - 11:01:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US