Introduction: This paper discusses the pros and cons of using Oracle stored procedure for encapsulating SQL. We will also look at the option of storing SQL within the application code. We will use following benchmarks to compare the two 1. Ease of enterprise level development 2. Separation of code 3. Maintenance/support 4. Testing 5. Debugging 6. Performance 7. Security 8. Developers skill set 9. Transaction (Complex business Logic) For sake of simplicity, the term ‘Stored Procedure’ or ‘Stored Function’ are interchangeable. ‘Package’ is a grouping of related elements. Application code can be a VB, C# or PHP code for a web or desk...
Sharing the unusual problems and solutions while developing applications using .Net. and AWS