Click here to Skip to main content
15,891,033 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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.
Posted
Updated 27-Apr-11 3:28am
v2
Comments
nitendrasingh 27-Apr-11 8:59am    
i know tese happened because of data mismatch so what to solve in query?
RDBurmon 28-Apr-11 2:05am    
Please share the complete query also tell me which are the column name in the query and which are the query keywords in the query.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900