|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
February 14th, 2005, 08:43 PM
|
|||
|
|||
|
Can I start and commit transations inside a SP?
I'm trying to wrap avery lengthy Insert command inside a SP, so it reports every thousand of records inserted an event to the monitoring app. But I just read that events are posted until the transaction is committed.
So the question is, can I start and commit a transaction inside a SP? or what the heck can I do to monitor a ~5 million record insert to give the user some visual progress estimate to when the &$#$" process is gonna end? Please help!!!
|
|
#2
February 15th, 2005, 01:33 AM
|
|||
|
|||
|
Quote:
You can try to use an output parameter , updated as inserts go on, and use a SUSPEND inside SP to make available for calling application.
|
|
#3
February 15th, 2005, 09:03 AM
|
|||
|
|||
|
Quote:
Geez... I knew it was so simple... thanks a lot!
|
|
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Can I start and commit transations inside a SP? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
