Devart Forums

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...

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.