Xref: alice comp.databases.oracle.tools:38070
Path: alice!news-feed.fnsi.net!newsfeed.icl.net!newspeer.clara.net!news.clara.net!colt.net!newsfeeds.belnet.be!news.belnet.be!afrodite.telenet-ops.be!not-for-mail
From: "Leo Van Nieuwenhuyse" <leo.van.nieuwenhuyse@pandora.be>
Newsgroups: comp.databases.oracle.tools
References: <Quoc4.3421$Ak.44263@news1.mia> <84t83l$hr8$1@kermit.esat.net> <Ylqc4.3656$Ak.46808@news1.mia>
Subject: Re: Help on running functions
Lines: 40
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <Jvuc4.1995$E92.14008@afrodite.telenet-ops.be>
Date: Tue, 04 Jan 2000 22:30:01 GMT
X-Complaints-To: abuse@pandora.be
X-Trace: afrodite.telenet-ops.be 947025001 213.224.5.79 (Tue, 04 Jan 2000 23:30:01 MET)
NNTP-Posting-Date: Tue, 04 Jan 2000 23:30:01 MET
Organization: Pandora-- Met vlotte tred op Internet

SET SERVEROUTPUT ON turns the output on
Tom Deseamus <tdeseamus@digital-hire.com> schreef in berichtnieuws
Ylqc4.3656$Ak.46808@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@phoenix.ie> wrote in message
> news:84t83l$hr8$1@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?
> > >
> > >
> >
> >
>
>