David, It would be helpful if you attached a small script which demonstrates the error.
I have had numerous instances using Oracle to have multiple sql statements executed and, in fact some executing concurrently. All using the same connection. Regards, Jeff > > 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- > >
