Forum OpenACS Q&A: FYI - bind vars in oracle :comment is not legal name

I've been updating some code from using regular tcl $vars to :bind_vars and I had a form that passes a field called comment so instead of
ns_db_whatever $db "DML_CMD $comment"

I use
db_whatever some_cmd "DML_CMD :comment"

Oracle doesn't like the name :comment

Oracle driver says:

ORA-01745: invalid host/bind variable name

I suppose that's a reserved word, etc..

I renamed the form var and bind var to acomment and everything worked fine.

Hope this helps somebody down the line :)

Posted by Alfred Werner on

xref - in that post it looks like 'size' is also not a valid name..