Cursors and PreparedStatements

Hi guys, i used the built-in google search to check if any previous posts might be relevant and found none so i am posting this question.

Our DBA is having troubles with having too many cursors with a specific sql. i am not authorized to post the exact sql. but here is a general idea.

initially, the table has 25+ fields all inserted using a PreparedStatement. statistically, this sql runs atleast 50-100 times a day.

within the database system, Oracle 10g to be specific, a trigger is created to fill the primary key field. this trigger is runned before the actual insert is runned.

now, i am already expecting the trigger as a source of the cursor population. i would like to ask if the PreparedStatement adds up that much as well.

Good Oracle DBAs are hard to find...

Also, are you sure all connections/statements are being regularly closed or is it one particular transaction that is hurting performance?

thanks scott for your time.

yes there is one statement not being closed properly. that one is already fixed. i would like to confirm however if the number of '?' in the PreparedStatement has something to do with it.

thanks again in advance.