PL/SQL - What is the disadvantage of out paramter in functions

GeekInterview.com > Interview Questions > Oracle > PL/SQL

Go To First | Previous Question | Next Question

PL/SQL | Question 187 of 241

What is the disadvantage of out paramter in functions

Total Answers and Comments: 3

Last Update: February 19, 2008 Asked by: Sushma

Sponsored Links

Best Rated Answer

—

Submitted by: g_sidhu

We cant use functions with OUT parameter in sql statements because there is no way for you to declare a variable in a SQL query and in order to call an IN OUT -- you need a local variable (to supply a value to be read from and to supply a place to put the out value into).

Above answer was rated as good by the following members:
rethishr, ratna82, ds_devi, kperumal75

July 05, 2007 03:02:52

rajeev369

RE: What is the disadvantage of out paramter in functi...

You can't call a function without parameter within select statement.

Is this answer useful? Yes | No

0 3

Overall Rating: -3

September 26, 2007 11:25:04

ramaswamy

RE: What is the disadvantage of out paramter in functi...

Functions with out parameters cannot be used in SQL statments however I disagree with you rajeev because functions without parameters can also be called in select statments as long as they havea return() (Eg: SYSDATE)

Is this answer useful? Yes | No

2 1

Overall Rating: +1

February 19, 2008 16:18:21

g_sidhu

Member Since: August 2007 Contribution: 122

RE: What is the disadvantage of out paramter in functions

We cant use functions with OUT parameter in sql statements because there is no way for you to declare a variable in a SQL query and in order to call an IN OUT -- you need a local variable (to supply a value to be read from and to supply a place to put the out value into).

Is this answer useful? Yes | No

3 1

Overall Rating: +2

Go To Top

User Name		Remember Me?
Password

Question Bank