From: | "Doug Thom" <dthom(at)iagr(dot)net> |
---|---|
To: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Brio returning data through stored procedures. |
Date: | 2007-04-05 23:05:53 |
Message-ID: | A9D51A18173BD043BC843DAFB9CA48EC9A79F4@VMAIL.iagr.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hello, all,
I am wondering if anybody knows how to return data to Brio through ODBC
from a function. If you are (or were) an Oracle user you may be familiar
with defining a ref cursor type and including that as an OUT parameter.
Brio then picks it up through ODBC and collects the results.
When I tried this in many different ways in Postgres the best I could
get returned was either "<unnamed portal x>" where x increments for the
number of times I tried it or what I passed in when I used the method
that allows me to have the calling procedure name the cursor. But no
data.
If anybody has run into this challenge I would love to hear if you were
or were not successful. I'd really like to hear you were successful, of
course, but if there is no way to do it then there's no point me wasting
any more time with it.
Thank you,
-Doug
From | Date | Subject | |
---|---|---|---|
Next Message | David Gardner | 2007-04-06 00:16:27 | Re: Brio returning data through stored procedures. |
Previous Message | noreply | 2007-04-05 20:46:25 | [ psqlodbc-Bugs-1000630 ] Related to bug GenerateBDDirectMethod fails in VS studio 2005 with ODBC |