how do I send null or empty date from aware IM to stored pro

swiftinitpvtltd

how do I send null or empty date from aware IM to stored procedure?

BLOMASKY

When you define the SP, you can have a DEFAULT value, so if your SP looks like this:

Create Procedure MYSP
@param1 varchar(20) = null

If you have a default value, then you can skip sending the param in your rule.

swiftinitpvtltd

Thank you! this worked.

UnionSystems

BLOMASKY wrote
When you define the SP, you can have a DEFAULT value, so if your SP looks like this:

Create Procedure MYSP
@param1 varchar(20) = null

If you have a default value, then you can skip sending the param in your rule.

You can do this in MS SQL but unfortunately not in mySQL as mySQL does not support defaults for stored procedure parameters (hope I’m wrong).