Re: [GENERAL] Ref cursor with Geometric Function

2006-01-16 Thread Jim C. Nasby
On Mon, Jan 16, 2006 at 02:20:23PM -0700, Michael Fuhr wrote: > On Mon, Jan 16, 2006 at 12:17:26PM -0800, [EMAIL PROTECTED] wrote: > > The following query is working when this is used by static cursor. This > > will return all the properties within the distance of 20 miles > [...] > > But When I a

Re: [GENERAL] Ref cursor with Geometric Function

2006-01-16 Thread Michael Fuhr
On Mon, Jan 16, 2006 at 12:17:26PM -0800, [EMAIL PROTECTED] wrote: > The following query is working when this is used by static cursor. This > will return all the properties within the distance of 20 miles [...] > But When I am trying to build the dynamic sql string to a refcursor it is > not abl