Re: Help on running functions

Thanks Leo, that worked.

Leo Van Nieuwenhuyse <leo.van.nieuwenhuyse_at_pandora.be> wrote in message news:Jvuc4.1995$E92.14008_at_afrodite.telenet-ops.be...
> SET SERVEROUTPUT ON turns the output on
> 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 Wed Jan 05 2000 - 01:49:04 CET