Bind variables in TOracleCommand?

[al0]

Hi,

Would you consider introducing a bind variables in TOracleCommand object? In some cases it is desirable to have them inside a script.

Yours,

Oleksandr

 

[Marco Kalter]

In most cases you can use substitution variables instead. If you must use bind variables, you could use the OnCommand and/or AfterCommand event handlers to access the variables of the Query property.

 

[al0]

Originally posted by Marco Kalter:
In most cases you can use substitution variables instead. If you must use bind variables, you could use the OnCommand and/or AfterCommand event handlers to access the variables of the Query property.

Substitution variables are not always completely Ok (if I have to execute the same script many times they may cause unnecessary parsing, especially in multiuser environment). But your suggestion concernig Query property is very useful, I haven't noticed such possibility myself as Query belongs to OracleScript itself, not to the OracleCommand.

Tnak you very much.

Oleksandr

 

[Marco Kalter]

Note that all commands share the same TOracleQuery instance of the TOracleScript. This may cause the reparse operations you are trying to prevent by using bind variables.

 

[al0]

Originally posted by Marco Kalter:
Note that all commands share the same TOracleQuery instance of the TOracleScript. This may cause the reparse operations you are trying to prevent by using bind variables.

IT doesn't matter - I'm interested to avoid hard parse on serverand for this it doesn't matter do they share the same query on client or no.