Execute Stored Procedure with parameter = ' ' ( space not blank)

Michael Illarietti

Good morning,

 

i try to Execute Stored Procedure in my OnButtonPressed Script for assign ( toDoList) any efolder to my (processContext.Username)

 

Connection :             MetastormDefault

Procedure name :  "METASTORMBPM.MBPM_ADMIN.ESP_INSERT_ALERT"

Parameters:             "@p_;userName=" + ProcessContext.UserName + ", @p_;folderID=" + Local.FolderID + ", @p_;alertType="  + Local.alertType

The problem is that Local.alertType value ' ' and i get this error:

 

Exception 'ORA-01400: cannot insert NULL into ("METASTORMBPM"."EALERT"."EALERTTYPE")
ORA-06512: at "METASTORMBPM.MBPM_ADMIN", line 531
ORA-06512: at line 1' occurred when attempting to 'Execute stored procedure'.

 

I think that Execute Stored Procedure script trim a space character in the parameters.

 

Is this a bug ?

 

Someone know this defect ?