How to send variable in select statement in VB.Net

  • Thread starter Thread starter k_mahesh7
  • Start date Start date
K

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
*---------------------------------*
 
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> *---------------------------------*
 
Back
Top