Hi,
I have a following code that will execute an Oracle stored procedure using SPT:
nH=sqlconnect('dbtest','sa','') && returns a positive number
?sqlsetprop(nH,'Asynchronous',.t.) && set to Asynch; returns a positive number
lcSQL = [{call testdb.sp_test}]
?sqlexec(nH,lcSQL) && start the stored procedure
?'Stored procedure started.'
My understanding of the Help topics for the SPT functions is that; SQLExec() will return 0 until done in Asynch mode, and that I have to continuously call SQLExec() until a non-zero value is returned.
However, the program execution stays in the SQLExec() line rather than continue to the next line. I just want to start the Oracle SP and continue executing the rest of the program. Are there other SPT settings that I should set as well?
Any feedback is very much welcome.
Thanks, Ramil 11/2
ramil
~~ learning to stand still