Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Jul 31, 2012 10:20 AM by Ajay2707
Jul 25, 2012 07:15 AM|LINK
have kept this query under try catch
it doesnt work, even it doesnt move to catch block
tried it in oracle, it is working.
Jul 25, 2012 07:36 AM|LINK
I think it is because you have omited Group By after using aggravative function, so try this , and add it at end of your statement.
group by EXCELLENT,VERYGOOD ,GOOD ,POOR,VERYPOOR
--if it it helpful remember check as helpful
Jul 25, 2012 09:51 AM|LINK
It takes 2 sec in toad to execute,
But through .net it goes on and on never ends,
the interesting thing is that, it happens only with this view, if i would execute any other view or tables from same schema
It executtes in less than a seconds.
Jul 26, 2012 04:17 AM|LINK
can you send your Field names , and also the error which appear after execution.
Jul 26, 2012 04:31 AM|LINK
Hi. I think you should write your code like this :
SELECT SUM(EXCELLENT) as EXCELLENT,SUM(VERYGOOD) as VERYGOOD,SUM(GOOD) as GOOD,SUM(POOR) as POOR, SUM(VERYPOOR) as VERYPOOR FROM V_ATT_GUAGE_CHART
group by EXCELLENT,VERYGOOD,GOOD,POOR,VERYPOOR,DEPARTMENT_CODE
==remember if it is helpful please vote as helpful.
Jul 31, 2012 10:20 AM|LINK
I am not clear about your problem. I think you run this query by an stored procedure and it not give response.
if yes, then you can use pl/sql tool to test your stored procedure by file menu -> new -> test window.
give there parameter value and check it. Also you check your execution path.
I think this help . Still you have prob. then paste your query and .net code whichever give problem.