It seems like you can define "procedures" in org-mode and call them from elsewhere, with args.

But I'm not sure how well-defined that process is; the documentation is not completely perfect yet I think. Here's one thing I'm trying that seems not to work.

I define a "procedure" as a named ref called recorddate with two args, ver and order. The idea is I could later call that with different values of those args.

#+NAME: recorddate(order="desc")

#+BEGIN_SRC sql :exports none :colnames no :results scalar

select Event.CreatedAt from Event join MachineInfo as MI on Event.MachineInfoId=MI.Id

where Event.CreatedAt is not NULL order by CreatedAt $order limit 1;

#+END_SRC sql

(BTW, I really like how $ vars are substituted into SQL. Nice.) But when I try to call it like this:

* earliest record is call_recorddate(ver="'.'", order="asc")

or like this:

#+CALL: recorddate(ver="'.'", order="asc")

and I try to export as LaTeX (or anything), I get

org-babel-ref-resolve: Reference 'recorddate' not found in this buffer

Is this supposed to work?

--
Gary