can i use dbms_output.put_line in a function u are telling as return statement

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

can i use dbms_output.put_line in a function u are telling
as return statement

Question Posted / arpitha2206

7 Answers
18043 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

can i use dbms_output.put_line in a function u are telling as return statement..

Answer / hamdy

Yes we can use dbms_output.put_line in a function,

Function is a subprogram used for do some business process
or some calculations and return value.
DBMS_output.put_line used for Print something to the screen

Is This Answer Correct ?

6 Yes

0 No

can i use dbms_output.put_line in a function u are telling as return statement..

Answer / babu

Functions are always called by a program and its duty is to
return a value to the calling program, on the other hand,
dbms_output is used to print something to the screen and it
would not be of any significance here.

Is This Answer Correct ?

4 Yes

0 No

can i use dbms_output.put_line in a function u are telling as return statement..

Answer / shail

The significance of using dbms_output can be while
debugging any plsql unit and nothing more.

Is This Answer Correct ?

4 Yes

0 No

can i use dbms_output.put_line in a function u are telling as return statement..

Answer / swapandeep

this statement is only used for print nothing more.

Is This Answer Correct ?

4 Yes

1 No

can i use dbms_output.put_line in a function u are telling as return statement..

Answer / a.jyothsna

instead of return we can't use document_output......
But for general we can use

Is This Answer Correct ?

3 Yes

2 No

can i use dbms_output.put_line in a function u are telling as return statement..

Answer / gourvendra singh

Yes we can use the dbms_output.put_line in a function and
it will print the msg when we execute Function_name, it
will not display any value if we use the function to return
a value, consider the following code:
create or replace function abc_test return char is
a varchar2(20);
begin
select dname into a from dept where deptno=20;
dbms_output.put_line('the dept is ');
return a;
exception
when others then
a:='no dept';
dbms_output.put_line('the dept is ');
return a;
end;

this will work.

Is This Answer Correct ?

5 Yes

4 No

can i use dbms_output.put_line in a function u are telling as return statement..

Answer / manoj

I agree with Babu with that there is no significance of
dbms_output...in the function..

Is This Answer Correct ?

0 Yes

0 No

Post New Answer