?
Solved

Error while executing a function in Debug mode using TOAD

Posted on 2004-05-01
5
Medium Priority
?
1,243 Views
Last Modified: 2013-12-12
HI,

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 :  vickieraj@yahoo.com

Rgds
Raj.
0
Comment
Question by:VickieRaj
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 3

Expert Comment

by:dbms_chu
ID: 10970559
I was not able to recreate your error.

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

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

Expert Comment

by:musdu
ID: 10970992
Hi,

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.

regards.
0
 
LVL 12

Accepted Solution

by:
catchmeifuwant earned 1000 total points
ID: 10974848
Go to View->Options-> Debugging

Increase the "seconds" in Debug Session timeout and check

0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

741 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question