Error while executing a function in Debug mode using TOAD


I have written a simple Oracle function. I want to execute this oracle function in debug mode in TOAD. I set the input value to the function using the set parameter dialog box. Now when i execute this function in debug mode i get the following error in a  message box

Probe: Timeout Error.

When i click ok , the Toad application hangs.

Something about the function.
Input value: Date
Return value : Date
It is a function that accepts input parameter any date and returns the friday of the earlier week of the input date.

Please help ASAP

email me at :

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

I was not able to recreate your error.

Here is the code that I tested through Toad and Oracle 9i

CREATE OR REPLACE FUNCTION f_lastfriday(i_dt in date) RETURN date IS
tmpVar date;
   for i in 1 .. 7
   if trim(to_char(i_dt - i,'DAY'))='FRIDAY'
   then tmpVar := i_dt - i;
   end if;
   end loop;
   RETURN tmpVar;
       -- Consider logging the error and then re-raise
END f_lastfriday;

does it runs in sql plus?

select last_friday(to_date('02/05/2004','DD/MM/YYYY')) from dual;

Kill your all sessions in DBA module of TOAD and try it again.

Go to View->Options-> Debugging

Increase the "seconds" in Debug Session timeout and check

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.