Thanks for your suggestions. I looked at option 1 and you are right, looks like it only works with tables. Other suggestions involve maintaining some kind of data access code external to OutSystems. It would be nice to connect to external entities via stored procedures using the data plumbing already built into Ousystems.
I looked at the link you had provided. Correct me if I am wrong, but It appears like that solution is tartgeted to stored procedures in the OutSystems database itself.