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/de...ic.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" <k_*******@hotmail-dot-com.no-spam.invalid> escribió en elmensaje news:41**********@127.0.0.1...>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> *---------------------------------*