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