I guess my difficulty in understanding this comes from my unfamiliarity with the SQLExec() command. It seems to me that I really must pass through this string "lcSQL" literal values for the variables as opposed to the variables themselves. My reasoning (again, I am a novice and may be over analyzing) is that once we pass the "lcSQL" it goes on over to some Oracle driver that will be unaware as to the values of "charvar1" and "charvar2". The solution would be simple if I was only dealing with characters and numbers and not dates. If it were just characters, then I could do this:

charvar1="09120920"
charvar2="20992"

lcSQL="{Call pwadm.PSINSRT('"+charvar1+"','"+charvar2+"') }"
rtn=SQLExec(h,lcSQL,"crsTest")

However, what does Oracle expect as the date delimiter in lcSQL? I know it is not the brackets below. Or, is all this unnecessary?

charvar1="09120920"
charvar2="20992"
datevar=datetime()

lcSQL="{Call pwadm.PSINSRT('"+charvar1+"','"+charvar2+"',["+datevar+"]) }"
rtn=SQLExec(h,lcSQL,"crsTest")