Pass NULL to Oracle stored procedure
Posted on 2006-04-19
I've got some server-side VBScript passing parameters to an Oracle stored procedure.
What I can't get to work, is passing a NULL value.
Lets say I have a stored procedure defined as:
CREATE OR REPLACE PROCEDURE my_proc(date_in DATE)
And VBScript calling it:
Set objCommand = Server.CreateObject("ADODB.Command")
Set objCommand.ActiveConnection = objConnection
On Error Resume Next
.CommandText = "my_proc"
.CommandType = 4
.Parameters.Append .CreateParameter("date_in", 133, 1, 4, date_val)
Is it possible to pass a NULL to the stored procedure as the date is optional? Everything I've tried has failed.
Thanks in advance,