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

Collapse
2: Re: Replacing SQL bind variables in Emacs (response to 1)
Posted by Rocael Hernández Rizzardini on 06/04/03 04:17 PM
cool Bart,
what about oracle, something like this?
(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)
)
Collapse
3: Re: Replacing SQL bind variables in Emacs (response to 2)
Posted by Bart Teeuwisse on 06/04/03 07:28 PM

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