This project has moved. For the latest updates, please go here.

Quick question on NVL

Feb 16, 2015 at 12:26 AM
Do NameValueLists accept different parameter values for creating different criteria? It seems it only accepts fixed parameters at generation level. In other words it doesnt work like ReadOnly lists where criteria allows to execute queries with different parameters each time. Am i correct?

For example i want to create a NVL on an table using a different type_id each time. Should i go with ROL instead?
Coordinator
Feb 22, 2015 at 10:25 PM
Hi pandelaras,
This is by design. If I remember correctly, the fixed value parameter is intended to be passed to the stored procedure. It isn't supposed to change because... I can't remember exactly. But yes, you are right: if you want more flexibility, go for ReadOnlyList.