I have done this for inserting procedure but not working for updating procedure
i tried this coding
type:
create type smp_emp_type as object
(id number(3), name varchar2(30), gender varchar2(1)) NOT FINAL;
table:
create table smp_emp
(id number(3), name varchar2(30), gender varchar2(1)) ;
insert_procedure:
CREATE OR REPLACE procedure ins1 (emp IN smp_emp_type) as
begin
Insert into smp_emp values (emp.id,emp.name,emp.gender);
end
CREATE OR REPLACE procedure upd1 (emp IN smp_emp_type) as
begin
update smp_emp e set e.name =emp.name,e.gender = emp.gender where id = emp.id;
end
both the procedures are created sucessfully
bt update is not working with my code:
update_pro updobj = new update_pro();
updobj._Id = Convert.ToInt16(textBox1.Text);
updobj._Name = textBox2.Text;
updobj._Gender = textBox3.Text;
OracleConnection conn = new OracleConnection("Data Source=r2;User ID=test;Password=test;");
conn.Open();
OracleCommand cmd = new OracleCommand("upd1", conn);
OracleParameter emp_obj = new OracleParameter();
emp_obj.OracleDbType = OracleDbType.Object;
emp_obj.Direction = ParameterDirection.Input;
emp_obj.UdtTypeName = "SMP_EMP_TYPE";
emp_obj.Value = updobj;
cmd.Parameters.Add(emp_obj);
cmd.ExecuteNonQuery();
showing error message as ORA-00900: invalid SQL statement;
plz help me to solve this