Re: Help on running functions

SET SERVEROUTPUT ON turns the output on
[Quoted] Tom Deseamus <tdeseamus_at_digital-hire.com> schreef in berichtnieuws Ylqc4.3656$Ak.46808_at_news1.mia...
> Thanks, I got another answer:
> SELECT functionname FROM DUAL;
> 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 - 23:30:01 CET