Hello,


we are using hibernate3.2/jboss 4.0 and oracle 9.2.0.3. When executing this one stored procedure, we are getting the following warn messages in jboss logs:

2006-03-15 11:19:45,119 INFO  [net.voicelog.callRecordingReports.ejb.ReportSessionBean]
{call pkg_callrecording_reports.pr_response_frequency(56, 326, '801', '03/09/2006 07:00:00', '03/10/2006 06:59:00',?) }

2006-03-15 11:28:50,412 WARN  [org.hibernate.util.JDBCExceptionReporter] SQL Warning: 17110, SQLState: null
2006-03-15 11:28:50,413 WARN  [org.hibernate.util.JDBCExceptionReporter] Warning: execution completed with warning

The warning continue on until jboss is restarted. We get this everytime this one stored procedure is exected. This procedure is nothing special compared to the other 12 I have. I can also run the stored procedure via sqlplus with no errors.
Enclosed is the package with the stored procedure.

stored procedure e xecution via sqlplus
SQL> execute  pkg_callrecording_reports.pr_response_frequency(56, 326, '801', '03/09/2006 07:00:00', '03/10/2006 06:59:00',:ref);

PL/SQL procedure successfully completed.
( I won't do the print :ref, but take more word for it it prints out fine)

Any ideas?

Thanks in advance,

Lizz

---

Yahoo! Mail
Bring photos to life! New PhotoMail makes sharing a breeze.