database query execution - different methods

Bagieta · Post by **Bagieta** » Sun 12 Dec 2004 09:47

Can someone tell me
What is the difference between
ExecSQL(), ExecSQLEx(), OraSQL.Execute()

They all look the same.

Which one is the best to use if I want for example call something like
drop procedure...
or
create package...
or
kill session...

Paul · Post by **Paul** » Mon 13 Dec 2004 08:31

TOraSession.ExecSQL and TOraSession.ExecSQLEx are methods of TOraSession. ExecSQL takes the array of parameter values as argument. ExecSQLEx takes the sequence of pares (parameter name and parameter value) as argument.
TOraSQL.Execute is the method of TOraSQL.
TOraQuery.ExecSQL and TOraQuery.Execute are identical and were implemented for compartibility with different products, incuding BDE.