Forum OpenACS Development: Response to Basic question. How to run a pg stored procedure from tcl

Hi Tomas,

Since you are using xql files you can just ommit the body part and just go db_exec_plsql doc_insert "" on your tcl file.  The precedense of the Query dispatcher is foo-[dbname].xql, foo.xql then finally foo.tcl.

You may want to look at the APM.  go to http://foohost/acs-admin/apm.  Then click on the package where you have your xql.  Somewhere below the package there is "Manage files... blah".  After clicking here you will see a list of files for that package.  Scroll down and click on "scan for new files... blah".  Then add your xql.

Take the above with a big grain of salt since its been a while I have done OACS coding.  But I know this might help.