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 desktop application. Benefits of using stored procedure vs embedding SQL in application code · Using stored procedure can speed up enterprise level application development as one developer can focus on developing the database logic while other can focus on applica
Sharing the unusual problems and solutions while developing applications using .Net. and AWS