OracleParameter C# ORA-24338: statement handle not executed

  • Thread starter Thread starter tapeesh
  • Start date Start date
T

tapeesh

I have a stored procedure which takes 7 parameters as input and gives
one output. Of these 7 parameters there can be few parameters which
can take null value. I am using C# to connect with oracle. The
parameters are set using OracleParameter class. But whenever I make a
parameter null the sp is throwing an error "ORA-24338: statement
handle not executed ". Can somebody help? How can I send null values
to the sp.
 
Use the Oracle Types in the OracleClient namespace. Each has a .Null
property.

Param.Value = OracleString.Null;

The other option is to NULL out the parameter in the sproc:

CLIENT_NAME VARCHAR2 := NULL

and not even setting it in your .NET code.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************
Think Outside the Box!
************************************************
 
Back
Top