How to Execute Oracle Script in C#

Viewed 47

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

0 Answers
Related