I am working on a win32 perl script that reads sql from a text file maniputlates it then executes the statement on oracle. (the text report is a log of activities from a diffrent program) I have certain error conditions where I give the user an error and exit the program, in particular the one I am having problems with is in the event that the user has updated a record that has been deleted on the server. Now in my error procedure I report the error both to the screen and an error log, Rollback the transaction, then disconnect from my 2 databases,and exit. The first is an oracle connection that gives me an error when I try to disconnect "Disconnect invalidates 1 active statement handle ....call destroy of finish on statement before disconnect." I have tried to call destroy, finish, even undef on the statement, but I can't seem to find the first two and undef errors telling me I need to disconnect first. Finish is supposed to be in the DBI module which is what I'm using but the windows perl can't seem to recognize it. Any suggestions???
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
disconnect errors
- Thread starter kmcculler
- Start date
- Status