CODEWITHSUNDEEP
sqloracle-databasestored-procedures
Paari Thirugnanasambandam
Paari Thirugnanasambandam

Reputation: 37

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

Upvotes: 0

Views: 14684

Answers (1)

Ori Marko
Ori Marko

Reputation: 58774

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

Upvotes: 1

Related Questions