Thanks for your help guys but I'm actually calling an Oracle procedure from my SQL procedure.  We've managed to retrieve values returned from Oracle by changing the Oracle procs to return PL SQL...