Search the web
Sign In
New User? Sign Up
oo4ole · Oracle Objects for OLE (OO4O) Users List
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Show off your group to the world. Share a photo of your group with us.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Can Multiple procedure calls/SQL be in 1 transaction?   Message List  
Reply | Forward Message #1599 of 1863 |
Using VB 6.0 I open a transaction, issue an insert SQL statement then
call a procedure and close the transaction. The Code stops on the
procedure call and hangs unless the transaction is commited ( the
insert). When debuging if I fly oever the procedure call code

Set PLSqlStatement = mvarUpdateDatabase.CreateSql(procstr, 0&)

I see OIP-04154: Operation is valid only when non-blocking operation
is in progress

Questions?
Can I check the oo4o blocking state before executing this line?
Since the code hangs the error is not thrown, is this a 0040 bug?
Is a procedure a transaction with oo4o and one can not call multiple
procedures or mix procedure calls with sql executes with in a
trancation?





Thu Apr 1, 2004 3:19 pm

john_rainey5908
Offline Offline
Send Email Send Email

Forward
Message #1599 of 1863 |
Expand Messages Author Sort by Date

Using VB 6.0 I open a transaction, issue an insert SQL statement then call a procedure and close the transaction. The Code stops on the procedure call and...
john_rainey5908
Offline Send Email
Apr 1, 2004
3:20 pm
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help