Monday, May 28, 2007

What is a Bind Variable In Oracle Reports

Bind parameters are used to substitute single value at runtime for evaluation and are identified by a preceding :.

An example of a bind parameter in a select statement is provided below, where :P_Name is the bind parameter reference.

Select Name,Value

From XX_Table

Where Name= :P_Name

These are used as tokens while registering concurrent program