Skip site navigation (1) Skip section navigation (2)

Re: Brio returning data through stored procedures.

From: David Gardner <david(dot)gardner(at)yucaipaco(dot)com>
To: Doug Thom <dthom(at)iagr(dot)net>, pgsql-odbc(at)postgresql(dot)org
Subject: Re: Brio returning data through stored procedures.
Date: 2007-04-06 00:16:27
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
Never worked with Brio, but have you defined a data-type in pgsql that 
your function would be returning? Something like:

("name" text,
"start" timestamp without time zone,
"end" timestamp without time zone,
error text);
ALTER TYPE "myType" OWNER TO "me";

then the function definition would start off like:

Doug Thom wrote:
> 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

In response to


pgsql-odbc by date

Next:From: noreplyDate: 2007-04-06 02:09:05
Subject: [ psqlodbc-Bugs-1002827 ] ODBC logging not working in Windows Vista with UAC on
Previous:From: Doug ThomDate: 2007-04-05 23:05:53
Subject: Brio returning data through stored procedures.

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group