Postgres Pro
Downloads
Home   >   mailing lists

Multiple refcursor as INOUT parameter in procedure - Mailing list pgsql-admin

From Mukesh Rajpurohit
Subject Multiple refcursor as INOUT parameter in procedure
Date
Msg-id CAL+ptACoPuA8FVGkKr3Vn5_KRJZCDAXadH4j6i-Rvg+Upqh8mA@mail.gmail.com
Whole thread Raw
Responses Re: Multiple refcursor as INOUT parameter in procedure
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Avadhut Narayan Joshi
Date:
Subject: RE: Can we connect SSAS,SSIS,SSRS to PostgresSQL DB ?
Next
From: Vijaykumar Jain
Date:
Subject: Re: Multiple refcursor as INOUT parameter in procedure