what data provider are you using? should be smiliar if you are using System.Data.OracleClientfor ODP.NET, seehttp://www.c-sharpcorner.com/Code/2004/Feb/ODP.NET06.asp
but in System.Data.OracleClientyou need to use ":Name", not "@Name", myCommand.CommandText = "SELECT * FROM Emp WHERE Job = :pJob AND Sal = :pSal";see http://msdn.microsoft.com/library/en-us/cpref/html/frlrfsystemdataoracleclientoracleparametercollectionclasstopic.asp?frame=true
http://msdn.microsoft.com/library/en-us/cpref/html/frlrfsystemdataoracleclientoracleparametercollectionclasstopic.asp?frame=true