Re: Result set return to Coldfusion MX?

Avi Schwartz <avi(at)CFFtechnologies(dot)com> writes:

> Hi,
>
> We are currently running in a mostly Linux environment except for one
> (big) thing, the database server. We are currently using Coldfusion
> MX running on Linux and MS SQL Server but we are trying to get off SQL
> Server into a Linux DB. The thing is that we are using stored
> procedures very heavily and these stored procedures return a result
> set in many cases. I tried to use a pl/pgsql function to return a
> result set but it seems that Coldfusion MX does not know what to do
> with the refcursor that PostgreSQL is providing. Is there another way
> to return a result set to CF that it can handle? This is definitely a
> show stopper for us.

Have you tried using 7.3's set returning functions? See the docs...

-Doug