On Tue, May 28, 2002 at 03:59:55AM -0500, Barry Books wrote:
> I patched the ACS database routines somthing like
>
> catch {
> regsub {:} $sql {$} sql
> set sql [subst $sql]
> } err
>
> The regsub makes the bind variables TCL variables and subst replaces them
> with the value. The catch fixes dumb problems like where a = ':abc'. This
> goes right before the developer support call in the db routines. I also
> patched them so you can do dbms_output and capture it. I can dig up the
> exact patch later if you need it.Barry, so you effectively eliminated all use of bind variables? That doesn't seem like a good idea - I WANT to use bind variables. I'd just like some convenient way of including the values of the bind vars in any error message. Perhaps there's a simpler way, but I suspect I'd need to add that to the database driver (Oracle in this case). -- Andrew Piskorski <[EMAIL PROTECTED]> http://www.piskorski.com
