Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Asynch/Stored proc
Message
De
31/10/2008 16:11:26
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Asynch/Stored proc
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Divers
Thread ID:
01358785
Message ID:
01358785
Vues:
64
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
Répondre
Fil
Voir

Click here to load this message in the networking platform