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
|
||||
|
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]