Re: Help on running functions

Thanks, I got another answer:
SELECT functionname FROM DUAL;
[Quoted] and that worked. I tried yours as well and no errors, however no output either. I guess I need to figure out how to turn output on.

Keith Jamieson <jamiesonk_at_phoenix.ie> wrote in message news:84t83l$hr8$1_at_kermit.esat.net...
> you need to declare a variable of the type being returned.
> and then call it using
>
> variable := function(...);
>
> so
> it would be
> declare
> output varchar2(30);
> output := my_function;
>
>
> Tom Deseamus wrote in message ...
> >I have been running stored procedures in SQL worksheet using the execute
> >command
> >
> >execute procedurename
> >
> >How do you run a function?
> >
> >I've tried execute functionname and execute functionname() like in VB?
> >
> >
>
>
Received on Tue Jan 04 2000 - 20:46:27 CET