Lisp HUG Maillist Archive

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


Updated at: 2020-12-10 08:48 UTC