Forum OpenACS Q&A: calling a oracle plsql function from tcl

Collapse
1: calling a oracle plsql function from tcl
Posted by prashant harswal on 11/16/02 12:24 AM
Hello ,

I want to call an oracle plsql function named "get_unreserved_rooms" having an argument as revservation_date from say, "index.tcl".
The functions return a "varchar2". I need to use that return value ahead in my program. Is there any aolserver tcl command to accomplish this.

thanking.

Collapse
2: Re: calling a oracle plsql function from tcl (response to 1)
Posted by Jun Yamog on 11/16/02 09:49 AM
try to look at db_exec_plsql tcl api.  This is only available in openacs.  In case you need this in just plain aolserver either grab the proc or just study it.