OO4O preparing statements?

#1

Hi!
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?

Lots of Greetings!
Volker

#2

"Volker Hetzer" <volker.hetzer (AT) ieee (DOT) org> wrote

Quote:

Hi!
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?

Lots of Greetings!
Volker
I usually wrap them in a procedure and the first time they are called they

run and thereafter I call the refresh method.
Jim

#3

Jim Kennedy wrote:

Quote:

"Volker Hetzer" <volker.hetzer (AT) ieee (DOT) org> wrote in message
news:do9c6c$5fu$1 (AT) nntp (DOT) 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

#4

"Volker Hetzer" <volker.hetzer (AT) ieee (DOT) org> wrote

Quote:

Jim Kennedy wrote:
"Volker Hetzer" <volker.hetzer (AT) ieee (DOT) org> wrote in message
news:do9c6c$5fu$1 (AT) nntp (DOT) 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

#5

Jim Kennedy wrote:

Quote:

"Volker Hetzer" <volker.hetzer (AT) ieee (DOT) org> wrote in message
news:dobfo4$ebh$1 (AT) nntp (DOT) fujitsu-siemens.com...

Jim Kennedy wrote:

"Volker Hetzer" <volker.hetzer (AT) ieee (DOT) org> wrote in message
news:do9c6c$5fu$1 (AT) nntp (DOT) 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.
My statements were inserts.

Well, unfortunately, it turned out it was too slow anyway, even with array binds.
Next stop:sql*loader...
I really didn't expect it to be so hard loading a couple hundred thousand
spatial objects into a database.

Lots of Greetings and thanks nevertheless!
Volker

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

OO4O preparing statements?

comp.databases.oracle.misc comp.databases.oracle.misc

OO4O preparing statements? - 12-20-2005 , 10:40 AM

Re: OO4O preparing statements? - 12-20-2005 , 11:30 AM

Re: OO4O preparing statements? - 12-21-2005 , 05:53 AM

Re: OO4O preparing statements? - 12-21-2005 , 09:55 AM

Re: OO4O preparing statements? - 12-23-2005 , 04:15 AM