Progress
DataServer
for ORACLE Guide
Bind Variables
The DataServer has enhanced memory management for bind variables, which causes variables in SQL statements to be re-bound less frequently.
SQL SELECT statements use bind variables. When you use the SQL SELECT statement in a Progress procedure, the DataServer for ORACLE uses bind variables and generates reusable SQL.
For Progress queries that reference a DATE in the WHERE clause, the DataServer uses a bind variable instead of a literals for the DATE value and generates reusable SQL.
NOTE: The ORACLE DataServer does not substitute bind variables for values in SQL statements that you send directly to ORACLE using the Progress RUN STORED-PROC send-sql-statement syntax.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |