如何处理Oracle Reports中的数值和值错误? [英] How to handle numeric and value error in oracle Reports?

问题描述

我收到以下错误:-

I am getting follwing error:-

REP-300: PL/SQL: numeric or value error
ORA-06512: at "SYS.OWA_UTIL", line 356
ORA-06512: at "SYS.OWA_COOKIE", line 67
ORA-06512: at "SYS.OWA_COOKIE", line 183
ORA-06512: at "WWW_CLS.QSI_SESSION$", line 184
ORA-06512: at "WWW_CLS.QSI_SESSION$", line 273
ORA-06512: at "WWW_CLS.PERSON_NAME_PROCESS$", line 222
ORA-06512: at "WWW_CLS.STAFF$", line 1149
ORA-06512: at line 1
SELECT distinct cp . client_id , DECODE ( : i_report_type , 1 , prog . NAME || ' (' || prog . code || ')' , 2 , decode ( o . name , null , ' No Location' , o . NAME || ' (' || organization_code || ')' ) ) group_1 , INITCAP ( pc . last_name || ', ' ||

如果您需要更多信息，请告诉我.

If you need more information just let me know.

推荐答案

"，第184行 ORA-06512:位于"WWW_CLS.QSI_SESSION

", line 184 ORA-06512: at "WWW_CLS.QSI_SESSION

"，第273行 ORA-06512:在"WWW_CLS.PERSON_NAME_PROCESS

", line 273 ORA-06512: at "WWW_CLS.PERSON_NAME_PROCESS

"中，第222行 ORA-06512:位于"WWW_CLS.STAFF

", line 222 ORA-06512: at "WWW_CLS.STAFF

这篇关于如何处理Oracle Reports中的数值和值错误?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！