Try OpenEdge Now
skip to main content
DataServer for Oracle
Additional Features to Enhance DataServer Performance : Bind variables

Bind variables

The DataServer has enhanced memory management for bind variables, which causes variables in SQL statements to be rebound less frequently.
SQL SELECT statements use bind variables. When you use the SQL SELECT statement in an ABL procedure, the OpenEdge DataServer for Oracle uses bind variables and generates reusable SQL.
For ABL queries that reference a DATE in the WHERE clause, the DataServer uses a bind variable instead of a literal for the DATE value and generates reusable SQL.
Note: The DataServer does not substitute bind variables for values in SQL statements that you send directly to Oracle using the ABL RUN STORED-PROC send-sql-statement syntax.