How to send variable in select statement in VB.Net

[k_mahesh7]

I need tp bind a variable to a select and send to oracle database.

I have the value to be send in a variable but that variable to be
binded to the query as the database I an hitting is a siebel related
which is resulting performance issues if it is not a bind variable
*---------------------------------*
Posted at: http://www.GroupSrv.com
Check: http://www.HotCodecs.com
*---------------------------------*

 

[Carlos J. Quintero [.NET MVP]]

To bind an Oracle variable you need to use a Command object, which has a
Parameters collection to bind parameters. Your SQL statement must use
":myvariable" to denote the binded variable.

See:

http://msdn.microsoft.com/library/d...oraclecommandclassparameterstopic.asp--Carlos J. QuinteroMZ-Tools 4.0: Productivity add-ins for Visual Studio .NETYou can code, design and document much faster.http://www.mztools.com"k_mahesh7" <[email protected]> escribió en elmensaje need tp bind a variable to a select and send to oracle database.>> I have the value to be send in a variable but that variable to be> binded to the query as the database I an hitting is a siebel related> which is resulting performance issues if it is not a bind variable> *---------------------------------*> Posted at: http://www.GroupSrv.com> Check: http://www.HotCodecs.com> *---------------------------------*