Re: Returning a REF cursor

From: Mladen Gogala <>
Date: Sun, 31 Jul 2016 18:34:21 -0000 (UTC)
Message-ID: <>

On Sun, 31 Jul 2016 19:07:43 +0200, Michel Cadot wrote:

> No problem for me.
> Regards Michel

You have properly declared the v_data variable as SYS_REFCURSOR, and the OP did not. Also, if the cursor needs to be returned, maybe a function would be more appropriate than a procedure?

Mladen Gogala
The Oracle Whisperer
Received on Sun Jul 31 2016 - 20:34:21 CEST

Original text of this message