C# OracleCommand SQL Call Procedure with Params

Question

I would like to call a (Oracle) Procedure from C#. My Code:

try
{
    OracleConnection myOracleConnection = new OracleConnection(connectionString);
    myOracleConnection.Open();
    OracleCommand command = myOracleConnection.CreateCommand();
    command.CommandText = String.Format("BEGIN MISSINGTABLES ('{0}', '{1}'); END;", "PEKA_ERP_001", "ASE_ERP_001");
    command.CommandType = System.Data.CommandType.Text;
    command.ExecuteNonQuery();
    myOracleConnection.Close();
}
catch (OracleException e)
{
    throw e;
}
catch (Exception e)
{
    throw e;
}

The Procedure:

CREATE OR REPLACE PROCEDURE MISSINGTABLES (S1 IN VARCHAR2, S2 IN VARCHAR2) AS
BEGIN [...]

on command.ExecuteNonQuery(); I get an Exception..:

PL/SQL: Statement ignored
OracleException Unhandled

What I'm doing wrong?

Because I don't really know, how I use the Parameters. You can see, that I need them between the -> BEGIN ... END Statement. How to do then the Placeholders ..? — eMi
– eMi, Commented Jan 16, 2012 at 14:29
There are many tutorials on the web, did you even search before asking? — Oded
– Oded, Commented Jan 16, 2012 at 14:40

Oded · Accepted Answer · 2012-01-16 14:51:28Z

1

Did it :)

OracleCommand command = myOracleConnection.CreateCommand();
command.CommandText = "MISSINGTABLES";
command.Parameters.Add(new OracleParameter("S1", OracleType.VarChar)).Value = "PEKA_ERP_001";
command.Parameters.Add(new OracleParameter("S2", OracleType.VarChar)).Value = "ASE_ERP_001";
command.CommandType = System.Data.CommandType.StoredProcedure;
command.ExecuteNonQuery();
myOracleConnection.Close();

edited Jan 16, 2012 at 14:51

Oded

501k102 gold badges900 silver badges1k bronze badges

answered Jan 16, 2012 at 14:48

eMi

5,63810 gold badges63 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

C# OracleCommand SQL Call Procedure with Params

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related