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: 4615915B.2000305@yucaipaco.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Never worked with Brio, but have you defined a data-type in pgsql that 
your function would be returning? Something like:

CREATE TYPE "myType" AS
("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:
CREATE OR REPLACE FUNCTION "getData"()
RETURNS SETOF "myType" AS
.....

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

Responses

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-2014 The PostgreSQL Global Development Group