Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: OO4O preparing statements?

Re: OO4O preparing statements?

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Wed, 21 Dec 2005 07:55:19 -0800
Message-ID: <oIidnUoxEtPn5zTeRVn-qQ@comcast.com>

"Volker Hetzer" <volker.hetzer_at_ieee.org> wrote in message news:dobfo4$ebh$1_at_nntp.fujitsu-siemens.com...
> Jim Kennedy wrote:
> > "Volker Hetzer" <volker.hetzer_at_ieee.org> wrote in message
> > news:do9c6c$5fu$1_at_nntp.fujitsu-siemens.com...
> >>I'd like to prepare all my statements before I start collecting data.
> >>However, ExecuteSQL and CreateSLQ both run the statement as soon as they
> >>are called.
> >>Is there any way to create a statement without executing it?
> > I usually wrap them in a procedure and the first time they are called
they
> > run and thereafter I call the refresh method.
> Yes, but I wanted to get rid of that this-is-my-first-call stuff...
> But it looks like I'm stuck with it.
>
> Lots of thanks nevertheless.
> Volker

You could search for something that can't exist. It will do the query, but not return any rows.
Jim Received on Wed Dec 21 2005 - 09:55:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US