how to pass parameters to oracle procedure

Jul 15 2006 9:12 AM
hey i have been facing problem in passing parameters to an oracle stored procedure from c#.net. i think the connection is alright. kindly specify how to send a string and mention any changes that have to be done in the basic code of the procedure. kindly post the code also.... the procedure runs fine if it is executed from oracle directly.... comm.Parameters.Add("isno",Convert.ToInt16(txtserial.Text)); comm.Parameters[0].Direction = ParameterDirection.Input; comm.Parameters.Add("iname", txtname.Text ); comm.Parameters[1].Direction = ParameterDirection.Input; this is how i tried to pass an integer value and an string to oracle.... thanks in advance