How to execute PL/SQL anonymous block using ADO.Net
594028Feb 20 2008 — edited Feb 27 2008I tried executing this anonymous block using Microsoft Oracle .net data provider
and it failed
Here is the code
sb.AppendLine("declare l_empno number;");
sb.AppendLine(" BEGIN");
sb.AppendLine(" emp_ins(l_empno, 'test siva', 'job' , 100, to_timestamp('1/1/2002','MM/DD/YYYY HH:MI:SS.FF3') , 10000, 5,10 );");
sb.AppendLine(" END;");
I am using CommandType.Text when calling the above block
Thanks
-Siva