The column is define as allowing NULLS
The insert is something like :
INSERT INTO mytable(oneval, twoval, oneday) VALUE(lc1,lc2,ldate)

I run this and copy the output to the cliptext. It comes back with only the values of lc1 and lc2.
Like (“firstval”, “secondval”
that’s all it reads, not even close parentheses.

I declare ldate as I showed you before NVL(ldate, NULL) so that if it is null I want to insert a NULL.
I use what I have in the clipboard adding the NULL like this:(“firstval” “secondval”,NULL) and it runs
that's why I thought I needed to send a something to the sql sever.