Re: Profiler tool
From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Sat, 21 Jul 2001 21:50:00 GMT
Message-ID: <3B1C6951.D66A0BC6_at_exesolutions.com>
Date: Sat, 21 Jul 2001 21:50:00 GMT
Message-ID: <3B1C6951.D66A0BC6_at_exesolutions.com>
Steffen Ramlow wrote:
> i want a stored proc which returns a resultset, not only a cursor
>
> "Daniel A. Morgan" <dmorgan_at_exesolutions.com> wrote in message
> news:3B1B1AF3.3CFCCC7_at_exesolutions.com...
>
> > Let me see if I understand what you find difficult.
> >
> > OPEN refcursor_variable FOR
> > SELECT fields
> > FROM tablename
> > WHERE somecondition...;
What's the difference?
One is the data ... the other a pointer to the data. Either one can be used by any half-way intelligent front-end. Certainly by VB, ASP, XML, Java, etc.
Daniel A. Morgan Received on Sat Jul 21 2001 - 23:50:00 CEST