How can a procedure be run in Toad Data Point to return REF CURSOR/collection results?
When executing a procedure, no parameters are applied and no ref cursor results are displayed. Trying to run a procedure that requires parameters results in an error:
"PLS-00306: wrong number or type of arguments in call to <procedure>"
WORKAROUND:
Install a 32-bit Oracle client, connect to the database using this client, then execute the Ref Cursor procedure.
STATUS:
Waiting for fix in a future version of Toad Data Point.
