Oracle Stored Procedure
Hi
I am using Oracle 10G
I have a stored procedure which takes to input parameter and updates a row in a table
I am using the following code in C#
_cmd.CommandText = "Exec UpdateEmployee (" + custId + "," + name + ");";
_cmd.commandtype=commandtype.text;
_cmd.ExecuteNonQuery();
The above does not work for oracle database but works fine for sql server. Please help.
I do not know the names of stored procedure parameters at run time. I can just use their position
|