rajeev369

• Jul 5th, 2007

 

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

ramaswamy

• Sep 26th, 2007

 

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)

g_sidhu

 Profile 

• Feb 19th, 2008

 

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).