Jim Kennedy wrote:
> "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.
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
Received on Fri Dec 23 2005 - 04:15:44 CST
