Re: Function vs Function()-no input parms-

I gave it a try, but same result as the other attempts I have made. I can run it as test_function or test_function('') but not as test_function(). I can not use the parens, but if I do use them I must supply a value or I get "illegal function". I remain truly baffeled by this one, but thanks for trying !

Richard Elliott wrote:

> Thanks Bill, I'll give it a try!
>
> Bill Frost wrote:
>
> > You should do something like this:
> >
> > function test_func (junk varchar2 default '') return varchar2
> > is
> > begin
> > return 'test_func was here';
> > end;
> >
> > ---------
> > Then, you invoke it with test_func()
> >
> > :)BF
> >
> > Richard Elliott <bullseye_at_flash.net> wrote in message
> > news:370BF4E9.12CFDED5_at_flash.net...
> > > I wrote a function to return a specific table/row/column. It needs no
> > > input parms. To execute this function I just reference it in the sql
> > > directly. ie
> > >
> > > select get_accounting_date from dual;
> > >
> > > The problem, a small but annoying one, is I want it to look like a
> > > function, ie
> > > select get_accounting_date() from dual;
> > >
> > > The way it is now it looks like a column name, not a function. I have
> > > tried default null parms but then I am forced to supply a value in the
> > > reference ie
> > > select get_accounting_date(' ') from dual.
> > > There has to be a solution, other functions work the way I would like
> > > this one to, like sysdate() etc...
> > > I have quite a few of these and I would really like for the SQL to be
> > > more readable by using the () with every function.
> > > I really have tried everything I can think of to get it to work with
> > > select get_accounting_date().
> > >
> > > Thanks in advance for your help.
> > >
> > >
Received on Fri Apr 09 1999 - 19:13:27 CDT