SQL parsing

[IanMorrison]

I am performing a lot of insert operations into a table and Oracle is parsing each SQL statement, even though I am using bind variables and the statement is always the same (except for the value of the variables).

How can I get Oracle to not parse the statement every time, ie it should only parse it once???

Ian.

 

[Marco Kalter]

The insert statement should only be parsed once, unless:

[*]You call TOracleQuery.Close between inserts.

[*]You have set TOracleQuery.Optimize to False.

[*]You change the SQL or variable types between inserts.

[*]One or more variables are long, long raw, clob or blob.[/list]
Perhaps one of these situations apply?

------------------
Marco Kalter
Allround Automations

 

[IanMorrison]

Thanks Marco,

I did have a long raw variable defined. After changing this to a string I did stop the re-parsing.

I did not really need a long RAW, but I did want to use a RAW variable. Does DOA support RAW variables? I noticed there is otRaw, but I could not find a function similar to SetLongVariable?

Ian.

 

[Marco Kalter]

Raw variables can be treated as hexadecimal strings.

------------------
Marco Kalter
Allround Automations