Home » Applications » Oracle Fusion Apps & E-Business Suite » Toad
Toad [message #205877] Tue, 28 November 2006 00:27 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 #205992 is a reply to message #205877] Tue, 28 November 2006 05:23 Go to previous messageGo to next message
David.K.Dickson
Messages: 413
Registered: October 2005
Location: Surrey, England
Senior Member
I am sorry, but I don't know how to help you myself, but I suspect somebody who subscribes to this forum may very well do. If not, then take a look at http://www.toadworld.com/ and I am sure that you will find an answer there.

Cool HTH

David
Re: Toad [message #206022 is a reply to message #205877] Tue, 28 November 2006 06:28 Go to previous messageGo to next message
vin_odks
Messages: 153
Registered: July 2006
Location: -
Senior Member
Hi,

Hope CREATE or REPLACE statement is present !!!



Regards
Vinod
Re: Toad [message #206065 is a reply to message #205877] Tue, 28 November 2006 08:43 Go to previous messageGo to next message
DiscoUser
Messages: 9
Registered: November 2006
Junior Member
Create the procedure in Procedure Editor.
Example:

CREATE OR REPLACE PROCEDURE test123(x in number, y in number)
AS
XY number;
BEGIN
XY := x * y;
dbms_output.put_line(XY);
END test123;

Right Click on it and click on compile, or hit F9.

When no errors, Go to Schema Browser and locate your Procedure.
Right Click and select Execute.

You can also try writing a script in SQL editor window as

begin
test123(5,4);
end;

and execute it. Click on the DBMS Output Tab in the bottom half window to view the output.

Hope this helps.
DU.
Re: Toad [message #206149 is a reply to message #205877] Tue, 28 November 2006 23:44 Go to previous messageGo to next message
lakshmi surya ram
Messages: 188
Registered: June 2006
Location: HYDERABAD
Senior Member

Hi DiscoUser,

Thanks a lot its working......Is that the same with functions,cursors also?I will keep trying in those areas,if not please tell me way.
regards,
Surya
Re: Toad [message #206150 is a reply to message #205992] Tue, 28 November 2006 23:45 Go to previous messageGo to next message
lakshmi surya ram
Messages: 188
Registered: June 2006
Location: HYDERABAD
Senior Member

Hi David,

I had gone through but not able to fulfill my need.

thanks,
Surya
Re: Toad [message #206366 is a reply to message #206149] Wed, 29 November 2006 14:25 Go to previous messageGo to next message
DiscoUser
Messages: 9
Registered: November 2006
Junior Member
Yes its the same for Functions and I guess for Cursors too(not very sure). For Cursors, you should be able to write any code in SQL Editor. Try this in SQL editor and see if you can see the output in DBMS Output tab. Replace TABLENAME with a valid table and COL1, COL2 with any 2 columns of that table.

declare
cursor cur is select * from TABLENAME;
rec TABLENAME%rowtype;
begin
open cur;
loop
fetch cur into rec;
exit when cur%notfound;
dbms_output.put_line('a: ' || rec.COL1 || ', b: ' || rec.COL2);
end loop;
end;
Re: Toad [message #206397 is a reply to message #205877] Wed, 29 November 2006 22:13 Go to previous message
lakshmi surya ram
Messages: 188
Registered: June 2006
Location: HYDERABAD
Senior Member

Hi DU,

Cursor is Working in SQL Editor and also the DBMS Output.

Thanks,
Surya
Previous Topic: Very Very Urgent
Next Topic: Payables LOV
Goto Forum:
  


Current Time: Sun Dec 04 18:56:02 CST 2016

Total time taken to generate the page: 0.04413 seconds