problem passing parameters to oracle procedure

[the_auracle]

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.... thanks in advance....

 

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....

[PlausiblyDamp]

http://www.xtremedotnettalk.com/showthread.php?t=87690 may be worth a look.