You might try the documentation
https://openacs.org/api-doc/proc-view?proc=db_1row
db_1row does what you need. There are thousands of exampels in the toolkit. If you do not specify column_array the columns popular tcl variables named for the columns as you want.