Hi all,
We're trying to call an Oracle stored procedure from VFP and pass it parameters and get back a result set via SQL pass-through (SQLExec function). Has anyone done this succesfully and could share their syntax with me? The version of Oracle we're using is 7.3.2.1 running on UNIX and VFP 6.0 running on NT/Novell.
We've succesfully implemented SQL pass-through and views for getting at Oracle tables but this stored procedure thing looks to be a bit more involved.
Thanks for any and all help and happy holidays!
-JT
Jeff Trockman, MCP