How to return oracle output parameters from a stored procedure in .NET

by

It seems you cannot use existing variable as output parameter, try this way instead

ora_cmd.Parameters.Add("Lc_Exito", OracleDbType.Int32).Direction = ParameterDirection.Output;

ora_cmd.ExecuteNonQuery();

if (ora_cmd.Parameters["Lc_Exito"].value == 0)

More Related Contents:

  1. Calling Oracle stored procedure from C#?
  2. Can the Oracle managed driver use async/await properly?
  3. How can I deploy a .NET application that uses ODAC without installing the whole component to the user?
  4. OracleParameter and IN Clause
  5. OraOLEDB.Oracle provider is not registered on the local machine
  6. Get all checked nodes of a treeview
  7. Is DateTime.Now the best way to measure a function’s performance? [closed]
  8. Double to string conversion without scientific notation
  9. OdbcConnection returning Chinese Characters as “?”
  10. Best way to compare two complex objects
  11. What exactly is an “open generic type” in .NET? [duplicate]
  12. What are attributes in .NET?
  13. Requested registry access is not allowed
  14. Immutability of structs [duplicate]
  15. Getting / setting file owner in C#
  16. What’s the best way of accessing field in the enclosing class from the nested class?
  17. Printing to a client printer from a web app
  18. .NET : How do you get the Type of a null object?
  19. How to check if IOException is Not-Enough-Disk-Space-Exception type?
  20. Send JSON via POST in C# and Receive the JSON returned?
  21. Why does the async keyword exist
  22. “new” keyword in property declaration in c#
  23. How to navigate a few folders up?
  24. Why does Environment.Exit() not terminate the program any more?
  25. How do you log the machine name via log4net?
  26. itextsharp – CSS not getting applied – C# .NET
  27. Target 32 Bit or 64 Bit native DLL depending on environment
  28. Creating an empty file in C#
  29. What is the use case for the (C# 7.2) “private protected” modifier?
  30. Method Overloading with different return type [duplicate]

Leave a Comment