Calling stored procedure ignoring output parameters

Question

I need to call MySql procedure as a plain text. Procedure has output parameter.
I'm not interested in returned data. What do I need to pass as output parameter to ignore it?

PS:

I know that using of SqlParameters is good and safe, but it is not my case.

Martin · Accepted Answer · 2010-07-07 13:15:22Z

1

Is this what you are looking for?

SqlConnection mySqlConnection = ConnectDB();
SqlCommand mySqlCommand = mySqlConnection.CreateCommand();
mySqlCommand.CommandText =
   @" 
      SQL QUERY HERE
   ";
mySqlConnection.Open();
mySqlCommand.ExecuteNonQuery();
mySqlConnection.Close();

answered Jul 7, 2010 at 13:15

Martin

10.6k13 gold badges66 silver badges84 bronze badges

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

1 Comment

Denis Palnitsky Over a year ago

Not exact. I need to call "MyStoredProcedure @outputParam"

Collectives™ on Stack Overflow

Calling stored procedure ignoring output parameters

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related