Hi there all,
apols in advance if this is a n00b question, however I've gone looking for the answer already and either nobody does this, or the question's phrased differently to what I'm used to...
How would one go about calling an Oracle stored proc which returns a REF CURSOR containing a resultset ? db_multirow and db_foreach only seem to accept a SQL string as input (assuming at this point, for whatever reason, that we're not using .xql files). db_exec_plsql sounds as if it should do the trick, however my experiments with it don't seem to be able to wrangle the resultset into a bind variable (as the cursor is returned as an output parameter rather than as the function return value).
All advice & pointers gratefully accepted !
Regards,
Jason
