Home › Discussions › Questions & Answers › Lexical Parameter Placeholder Usage
Customer · · Questions & Answers · 5 replies
I need to ensure a parameter value is inserted literally as text into the SQL, rather than being treated as a bind variable. This is necessary to force database reparsing when the value changes.
If you require the parameter value to show up as lexical text in the SQL, you must use the specific placeholder in the Parameter SQL text field.
What is the key benefit of using this method?
The primary benefit is enabling you to purposefully enforce reparsing for different parameter values, which can be useful for advanced dynamic SQL features.
And this must be combined with the &lexical anchor type?
Yes, this technique is used with the &lexical anchor, as that anchor type completely replaces the placeholder with the parameter SQL text at run-time.
Sign in with LinkedIn or Google to take part.
