Hi,

we are writing an application in C++ that needs to query Oracle and modify some data in underlying tables. As we have a lot of methods and attributes I was asked for the advantages of using dynamic SQL vs using static calls to a package with overloading of the parameters passed in package's procedures where necessary.

I know that dynamic SQL is useful for DML statements, and for flexibility, and I know that packages are useful for improving performance. But which solution is better in terms of performace ?

Therefore I thougt to share my doubts with You, as I really lack in experience in this field.

Thanks
Paolo