Hi,
I want to insert values in a DocStore.
This works manually:
INSERT INTO "dummy" values('{
"ID": "9993",
"v": "11",
"o": "B5000000B82",
"m": "0",
"n": "0",
"l": "DE"
}');
But in my code I've to Cast the values into a nvarchar
i.e.
Select
CAST("M" AS NVARCHAR(10)),
CAST("P" AS NVARCHAR(20)),
CAST("I" AS NVARCHAR(15)),
,...
After casting my values look like this in this object
INSERT INTO "dummy" values('{
"ID": "47",
"v": "01",
"o": "FB0000508901DE2C1600282C34CFBD2B",
"m": null,
"n": null,
"l": "de-DE"
}');
If I try it manually (sql console) then it works fine.
I think the problem is that it doesn't work with variables.
Get this error: invalid argument:
Tried Type as a Nvarchar and as a String.
i.e.
DECLARE lv_sM NVARCHAR(10);
DECLARE lv_sV NVARCHAR(20);.....
INSERT INTO "dummy" values('{
"M": lv_sM,
"v": lv_sV,
"U": lv_sU,
"a": lv_sA,
"z": lv_sZ,
"l": lv_sL
}');
Should it work with variables in stored procedures or are there any restrictions?
Thanks