Home » Other » 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

Report message to a moderator

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: 21807
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.

Report message to a moderator

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

Report message to a moderator

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)

Report message to a moderator

Previous Topic: Host command not working in sqlplus after cle scr
Next Topic: SQL Navigator: Can't retrieve datatype with timezone
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 07:31:24 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.