Search: For:
Browsing Single Category

STOP USING SO MUCH SQL IN PL/SQL - really?

Topic ID: 3052
Created By: 2008-FEB-22 21:26:41 [Vitaliy]
Updated By: 2008-FEB-23 02:12:11 [Vitaliy]
Status: Open
Severity: Normal
Read Only: No
8941
2008-FEB-22 21:26:41
Moderator
 
 
Registered On: Mar 2006
Total Posts: 191
This is a great discussion on ASKTOM where Steven Feuerstein is for removing 
inline SQL from your PL/SQL code and putting it into a generic PL/SQL procedure 
that is reused over and over again.  In one word this is what's called TAPI 
(table API's).

  VS

Where Tom Kyte is all for using inline SQL, hates TAPI's and instead promotes 
the use of XAPI.  XAPI is a term Tom came up with which stands for 
"Transactional API's".  In other words what Tom suggest is that for every 
business process there should be an XAPI.

I have much respect for Steven Feuerstein -- after all, years ago, I learned 
PLSQL from his book.  I also have much respect for Tom Kyte and consider his 
book Expert One on One Oracle to be the best 
ORACLE book ever written.

I also have to be honest here and admit that over the last two years I have 
developed a strong dislike for the way Tom replied to some of the questions and 
criticism on his website - asktom.oracle.com.  I belive that he's spent way too 
much time behind enemy lines so to speak and needs to really come down to the 
trenches with us mere mortals that do this job (Oracle DBA) day in and day out.

Having said that I 100% agree with Tom Kyte on this issue.  Nevertheless it's 
an interesting read worth your time regardless what your position is on this 
issue:

   Considering SQL as a Service
[edited by: Vitaliy at 02:12 (CST) on Feb. 23, 2008]