-
problem passing parameters to oracle9i from C#.net
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....
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|