java warn while executing a stored procedure - SQL Warning: 17110, SQLState: null

From: laura pena <lizzpenaorclgrp_at_yahoo.com>
Date: Wed, 15 Mar 2006 20:29:16 -0800 (PST)
Message-ID: <20060316042916.61265.qmail@web35015.mail.mud.yahoo.com>

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 execution 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.

--
http://www.freelists.org/webpage/oracle-l




application/octet-stream attachment: 175347831-sample.sql

Received on Wed Mar 15 2006 - 22:29:16 CST