I am a novice Perl DBI programmer currently having trouble referencing the same database handle (in Main) from within REPEATED calls to a perl subroutine I wrote as an engine to process multiple SQL statements (one call per SQL statement).
(I'm on Solaris 2.6.???, Oracle 8i, Perl5????) In other words, I get a "db prepare" error when I send the 2nd SQL statement from Main into the handle in the subroutine. The first statement executes fine and I get the results I want back from the database. It's just that 2nd pass to the same handle that kills the program. I was able to fix the problem by passing the 2nd SQL statement through a separate database handle (I pass both the database and statement handles to the subroutine). I have been playing with the object "finish" but haven't had any luck with it resolving the problem. But I thought Oracle DBI database handles were able to process multiple statement handles??????? I'd really like to use only one database handle for all statement handles because I've got a lot of SQL statements to process. I think it is ridiculous that I would have to create so many database handles to access the same database. Any suggestions would be GREATLY appreciated. I'm sorry I didn't supply more detail, but I'm not at my UNIX machine right now and am in a tight pinch to get this done). THANKS A LOT for any help. Please reply to both my addresses: [EMAIL PROTECTED] and [EMAIL PROTECTED] -Dave-
