Home » SQL & PL/SQL » Client Tools » Toad
Toad [message #205876] Tue, 28 November 2006 00:26 Go to next message
lakshmi surya ram
Messages: 188
Registered: June 2006
Senior Member

Hi folks,

Where can I view the output of a procedure or function or cursor in Toad.I had executed the program in procedure editor.
Iam getting the error as
No create(or Replace )found to ececute

Re: Toad [message #205886 is a reply to message #205876] Tue, 28 November 2006 00:48 Go to previous messageGo to next message
Messages: 21612
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
In order to create a function, syntax says that it must begin with the CREATE [OR REPLACE] FUNCTION ... Seeing your error message, it seems that your code lacks in this command. As you didn't provide actual code, it is impossible to say anything further.

How to see its output? Function does return a value - select it and you'll see it. Procedure? If it has an output argument, create an (anonymous) PL/SQL block and use DBMS_OUTPUT.PUT_LINE to check its output.

Or, use TOAD's debugging facility and go through the code step-by-step, set breakpoints and view variables' values.
Re: Toad [message #206017 is a reply to message #205876] Tue, 28 November 2006 06:21 Go to previous messageGo to next message
Messages: 340
Registered: November 2006
Location: Banglore
Senior Member

No Dear,
Thers Noway apart from using "DBMS_OUTPUT.PUT_LINE " in ur Procedure or Cursors Code in TOAD. Why not Using PL/SQL Developer its Pretty Good then Toad for Such Problems you can see the Output in the Same manner you 've asked.

Re: Toad [message #206037 is a reply to message #205876] Tue, 28 November 2006 07:03 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
What output are you expecting to see?

The procedure editor is for creating/modifying stored procedures, functions and packages - it does not execute them.

If you use an SQL window, then you can execute code there in just the same way as you would from SQL*Plus (without the support for SQL*Plus specific commands like ACCEPT and DEFINE)
Previous Topic: Host command not working in sqlplus after cle scr
Next Topic: SQL Navigator: Can't retrieve datatype with timezone
Goto Forum:

Current Time: Sat Oct 24 22:08:23 CDT 2020