Bind-variables in Common SQL (Oracle)
Hi. Conventional wisdom from Oracle is that bind variables (placeholders/sql with parameters) in SQL is a Good Thing and should be used as much as possible. That allows the oracle engine to parse statements only once, deciding on execution plans and caching them the first time a statement is run. The cursor can be reused on subsequent executions of the same query with different parameters. However, I can't find any mention of this mechanism in the documentation for Common SQL. Is it supported? -- Mvh/Regards Peder O. Klingenberg Netfonds Bank ASA