Paari Thirugnanasambandam Paari Thirugnanasambandam -4 years ago 36
SQL Question

stored procedures without parameters in 10g

To display my name using procedure

create or replace procedure auto is
vname varchar(20) :='manish';
begin
dbms_output.put_line('what is my name?'||vname);
end auto;


Procedure compilled sucessfully but cant set serveroutput on please help. I am using oracle 10g

Answer Source

For PL SQL Developer Client:

create or replace procedure auto is
  vname varchar(20) :='manish';
 begin 
 dbms_output.enable();
 dbms_output.put_line('what is my name?'||vname);
end auto;

to view output execute (right click on procedure and Test):

begin
  -- Call the procedure
  auto;
end;

and then click on DBMS Output tab

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download