I have an app written in VB6, using oracle client 7.3.3 (0040 v 3, I think). The database is oracle 8.1.5. When I installed a newer Oracle client (8.1.7), my app just freezes up when calling a stored procedure that performs an insert. I have traced it down to the .DBExecuteSQL call, from vb6. It worked just fine with 7.3.3, which is very puzzling. Has anyone seen anything like this before? Would you suppose it is a client issue? Database issue? Perhaps it's a problem with the stored procedure?
Any help you would be able to provide would be greatly appreciated. Thank you