Forum OpenACS Development: Re: Replacing SQL bind variables in Emacs

Collapse
Posted by Bart Teeuwisse on

Rocael,

to be honest, I'm not 100% sure if Oracle places the same quotes (') around the bound values as Postgres does. If it doesn't you'd have to modify xql-query-bind-and-send. Provided that both databases can use the same function, you'd have to add:

(defadvice sql-oracle (after sql-oracle)
  "Use xql-query-bind-and-send for `comint-input-sender'."
  (setq comint-input-sender 'xql-query-bind-and-send)
)
(ad-activate 'sql-oracle)

The ad-activate is important, it activates the defined advise. If you leave it out, nothing will happen.

/Bart