Quick question on NVL

Feb 15, 2015 at 11:26 PM
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?
Feb 22, 2015 at 9: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.