Please Help Me, how to execute the oracle script below in C#
set serveroutput on size 1000000
DECLARE v_ret_val VARCHAR2(300);
BEGIN
v_ret_val := APPS.something.main2(
p_delivery_name => '987654321',
p_transaction_date => '31/10/2000',
p_move_line_id => 123456789,
p_org_id => 1);
END;
And here is my c# code
public string updateDatePickConfirm(string strDeliveryName, string strTrandate, string strMoveLineID)
{
try
{
ora.OracleConnection connOra = new ora.OracleConnection(MyConsString);
connOra.Open();
ora.OracleCommand oraCMD = new ora.OracleCommand("APPS.something.main2", connOra);
oraCMD.BindByName = true;
//oraCMD.CommandText = @strQuery;
oraCMD.CommandType = System.Data.CommandType.StoredProcedure;
oraCMD.Parameters.Add("p_delivery_name", OracleDbType.Varchar2, strDeliveryName, ParameterDirection.Input);
oraCMD.Parameters.Add("p_transaction_date", OracleDbType.Date, strTrandate, ParameterDirection.Input);
oraCMD.Parameters.Add("p_move_line_id", OracleDbType.Int32, strMoveLineID, ParameterDirection.Input);
oraCMD.Parameters.Add("p_org_id", OracleDbType.Int32, 1, ParameterDirection.Input);
oraCMD.ExecuteNonQuery();
connOra.Close();
return string.Empty;
}
catch (Exception ex)
{
throw ex;
}
}
[edit]
here is Error message when the c# runned
ORA-06550: line 1, column 7:
PLS-00221: 'MAIN2' is not a procedure or is undefined
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
I had spent 2 days to figure out the solution but still stuck. so please help me