Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Asynch/Stored proc
Message
From
31/10/2008 16:11:26
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Asynch/Stored proc
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01358785
Message ID:
01358785
Views:
63
Hi all,
Consider that the stored procedure runs an average of 15 minutes. This code does not run asynch and vfp continues to pause until the stored procedure finishes.
* assume connection handle is valid
nH=sqlconnect(myconn)
sqlsetprop(nH,"Asynchronous",.t.) && or sqlsetprop(0,"Asynchronous",.t.)
if sqlexec(nH,"begin my_pkg.my_stored_proc();end;") < 0
   ? "error"
else
   ? "sp ran asynch"
endif
I just want to confirm if there is such a thing as an Asynch execution of an Oracle stored procedure using sqlexec() or not.
ramil
~~ learning to stand still
Reply
Map
View

Click here to load this message in the networking platform