Multiple refcursor as INOUT parameter in procedure

From: Mukesh Rajpurohit <vivasvan1902(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Multiple refcursor as INOUT parameter in procedure
Date: 2021-07-22 12:33:12
Message-ID: CAL+ptACoPuA8FVGkKr3Vn5_KRJZCDAXadH4j6i-Rvg+Upqh8mA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi All,
I have one procedure which has 4 input parameter as refcursor
and they are as INOUT parameter.

Now, I want to call that procedure in begin end; block and want to display
those 4 refcursor result in pgadmin. I tried multiple option like unnamed
portal, declare a refcursor and use in fetch all from..into...etc. But, no
option is showing result.

Please help if there is some solution for this, I tried all option
available in sites but it did not worked.

Thanks in advance,
Mukesh

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Vijaykumar Jain 2021-07-22 12:47:19 Re: Multiple refcursor as INOUT parameter in procedure
Previous Message Avadhut Narayan Joshi 2021-07-22 06:39:46 RE: Can we connect SSAS,SSIS,SSRS to PostgresSQL DB ?