Pass null to stored procedure

Classic Servoy
1

Hi all,

I need to pass a null to a stored procedure but when I try the below

args[0] = v_doNumber;
args[1] = ‘PDEG_TEST’;
args[2] = 10;
args[3] = 0;
args[4] = 337;
args[5] = null;
args[6] = null;

I get a ‘Parameter# x has not been set’ error, I also tried args[6] = var null; but no succes.
So my question is how do i pass the null to the SP.

TIA,

Peter

2

Did You try ‘’ (two single quotes) instead of null ?

3

hi Hans,

I tried the single quotes, but that does not work, I get the following err

JSDataSet:exception:com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: The INSERT statement conflicted with the FOREIGN KEY constraint “FK_Document_Subcode”. The conflict occurred in database “DC2_live”, table “dbo.Subcode”, column ‘sc_id’. The INSERT statement conflicted with the FOREIGN KEY constraint “FK_Document_Subcode”. The conflict occurred in database “DC2_live”, table “dbo.Subcode”, column ‘sc_id’.

I must pass null or a INT, passing a INT value is no option.

Regards

Peter

4

Peter de Groot:
I tried the single quotes, but that does not work

Did you find a solution for this?

Thanks