Solved

Error while executing a function in Debug mode using TOAD

Posted on 2004-05-01
5
1,240 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 250 total points
ID: 10974848
Go to View->Options-> Debugging

Increase the "seconds" in Debug Session timeout and check

0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and theā€¦
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
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

724 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