Re: EXEC syntax for SP which returns row set

Sorry about that, SPTEST and TEST2 are really the same. I changed the names of the procedure. tables, columns, etc to simplify the post (real code is much more complex), but I made a mistake.

The commands I used in SQL*Plus to succesfully test the funciton (I changed it from SP to funciton) are as follows:

var results refcursor
exec :results := TEST.SPTEST
print results Received on Thu Jul 14 2005 - 02:35:10 CDT