altinfiyatlari##
New Member
My code:\[code\]OracleCommand oracleCom = new OracleCommand{ Connection = oraConnect, CommandText = @"declare P_ID tbl_objects.i_id%TYPE; BEGIN insert into tbl_objects (s_code, i_status_id) values 
s_code, 234) RETURNING I_ID INTO 
_id; END;"};oracleCom.Parameters.Add("s_code", OracleType.NVarChar).Value = http://stackoverflow.com/questions/14080662/objectsChanged[j];oracleCom.Parameters.Add("p_id", OracleType.Number).Direction = ParameterDirection.Output;try{ oracleCom.ExecuteNonQuery();}catch{----------}\[/code\]The compiler generates an error:Wrong name/number of the variable.But when i use this sql in pl/sql developer everything works correctly.
s_code, 234) RETURNING I_ID INTO _id; END;"};oracleCom.Parameters.Add("s_code", OracleType.NVarChar).Value = http://stackoverflow.com/questions/14080662/objectsChanged[j];oracleCom.Parameters.Add("p_id", OracleType.Number).Direction = ParameterDirection.Output;try{ oracleCom.ExecuteNonQuery();}catch{----------}\[/code\]The compiler generates an error:Wrong name/number of the variable.But when i use this sql in pl/sql developer everything works correctly.