Recent content by Edcile

I just did a search and found this folder but the most current file in this folder is from the 5th which is well before I started having this issue. I am not sure what this means but that is what I found :) I am not sure what you mean by did it result in an ORA-03113. If you are asking if I...

I did not mention that adding the code to raise the applicaitno error did not seem to change the fact that PL/SQL Developer goes into a state of not responding after I attempt to execute the stored procedure in question. Thanks again for all your assistance.

I looked even more into this and I think that I do not understand enough about the error/warning that is returned from the function that I am using. When I execute the function FN_Rate it is supposed to return one value. However, becuase of some bad data it was returning multiple rows. Now...

Sorry for not explaining further. The statement actually does a Join on two tables that have 2,000,000+ rows then groups by two columns and then does a SUM and ROUND on the response from a function. The issue that I was having was that the function was returning multiple rows and therefore and...

I am a novice at administering Oracle so you will have to give me a bit more information about where to look for the Trace Dump file. I did do some more investigating and found that the combination of factors here is that it is a long SQL Execution and there is an error in the execution. I...

I am having trouble with SQL statements that take an extended period of time to return a result set. Basically, I execute the SQL statement or Stored Procedure and I see the Session open up on Oracle and it apears to be processessing then after a long time the Session dissapears but nothing is...