write a procedure to print a statement or number not using "dbms

write a procedure to print a statement or number not
using "dbms_output.put_line" package.write a procedure
instead of it using procdure name as "print"
ex:-

declare
a number:=2;
begin
print(a);
end;
/* when U type above procedure 2 have to should be printed*/

Question Posted / gireesh.p.v

2 Answers
7240 Views
iFlex, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

write a procedure to print a statement or number not using "dbms_output.put_line" packa..

Answer / chandra shekhar

As you said that DBMS_OUTPUT.PUT_LINE should not be used in given piece of your program, so it can be done by creating a procedure by name print as follows

create or replace procedure print(n number)
as
begin
dbms_output.put_line(n) ;
end ;

and then executing your piece of code i.e.

declare
a number:=2;
begin
print(a);
end;

Hope this is what u r question reflects ?

Is This Answer Correct ?

3 Yes

2 No

write a procedure to print a statement or number not using "dbms_output.put_line" packa..

Answer / amit kumar(patna)

We have to create procedure for print and called the SP for print any message
create or replace procedure print(n varchar)
as
begin
dbms_output.put_line(n) ;
end ;

set serveroutput on
declare
a number;
begin
a:=20;
print(a);
end;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer