Stored Procedure Interview Question:

Explain about the difficulties faced by the database developer in implementing pre compiled statements?

Submitted by: Administrator

There are many difficulties for implementing pre compiled statements because it should have all the arguments provided to it during compile time. It also depends upon the database and configuration. Performance also varies and it largely depends upon whether it is a generic query or user defined functions.
Submitted by: Administrator