Home » SQL & PL/SQL » Client Tools » How to execute pl/sql block in Toad 9.0 (toad, 9.0, XP)
How to execute pl/sql block in Toad 9.0 [message #331054] Wed, 02 July 2008 04:08 Go to next message
jyothsna1612
Messages: 68
Registered: June 2008
Member
Hi
I'm new to TOAD
I've following pl/sql block
declare
   var1 tab1%rowtype;
begin
   select * into var1
   from tab1 
   where c=5;
   dbms_output.put_line(var1.a);
end

How to see the output for this code in toad??
I selected the code and hit F9. Then it's saying

Pl/Sql procedure is successfully completed but no o/p is showing
I even set the set serveroutput on
but still no use...
Re: How to execute pl/sql block in Toad 9.0 [message #331071 is a reply to message #331054] Wed, 02 July 2008 04:51 Go to previous message
jyothsna1612
Messages: 68
Registered: June 2008
Member
Hello

I came to know that
If we select the code and press F5 then we get the required o/p
Previous Topic: Multiple Database Updates
Next Topic: SQLPlus Prompt Cursor Misplaced
Goto Forum:
  


Current Time: Sun Dec 04 08:49:50 CST 2016

Total time taken to generate the page: 0.18025 seconds