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
Location: HYDERABAD
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

thanks,
surya
Re: Toad [message #205886 is a reply to message #205876] Tue, 28 November 2006 00:48 Go to previous messageGo to next message
Littlefoot
Messages: 20894
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
javed.khan
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.


Jak
Re: Toad [message #206037 is a reply to message #205876] Tue, 28 November 2006 07:03 Go to previous message
JRowbottom
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: Mon Dec 05 12:41:09 CST 2016

Total time taken to generate the page: 0.08274 seconds