OraFAQ Forum: Client Tools

Home » Other » Client Tools » Toad

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Toad [message #205876]

Tue, 28 November 2006 00:26

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

Littlefoot
Messages: 21826
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

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Sep 06 06:34:36 CDT 2025