Re: Returning a REF cursor
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sun, 31 Jul 2016 18:34:21 -0000 (UTC)
Message-ID: <pan.2016.07.31.18.34.21_at_gmail.com>
Date: Sun, 31 Jul 2016 18:34:21 -0000 (UTC)
Message-ID: <pan.2016.07.31.18.34.21_at_gmail.com>
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 http://mgogala.byethost5.comReceived on Sun Jul 31 2016 - 20:34:21 CEST