OraFAQ Forum: SQL & PL/SQL » dbms_output

Home » SQL & PL/SQL » SQL & PL/SQL » dbms_output_put problem

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

dbms_output_put problem [message #41256]

Thu, 12 December 2002 06:50

Gurdeep Singh
Messages: 64
Registered: October 2002

Member

i have code
set serveroutput on;

create or replace procedure p(a number) as
begin
for i in 1..a
loop
dbms_output.put('*');
end loop;
end;
/
exec p(5);
/
it does not give any output
but when i change the code

create or replace procedure p(a number) as
begin
for i in 1..a
loop
dbms_output.put_line('*');
end loop;
end;
/
exec p(5);
/
it shows output like
*****
*
*
*
*
*

i want to take output horizontally. please help.
Thanks

Report message to a moderator

Re: dbms_output_put problem [message #41258 is a reply to message #41256]

Thu, 12 December 2002 06:57

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

SQL> ed
Wrote file afiedt.buf

  1  create or replace procedure test (a in number)
  2  as
  3  d varchar2(100);
  4  begin
  5  for mag in 1..a loop
  6     d:=d||'*';
  7  end loop;
  8  dbms_output.put_line(d);
  9* end;
SQL> /

Procedure created.

SQL> exec test(5);
*****

PL/SQL procedure successfully completed.

SQL> exec test(10);
**********

PL/SQL procedure successfully completed.

Report message to a moderator

Previous Topic:	connect to remote machine
Next Topic:	SOME DOUBT

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 15 11:27:57 CDT 2024