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