Re: Help on running functions
From: Keith Jamieson <jamiesonk_at_phoenix.ie>
Date: Tue, 4 Jan 2000 16:44:22 -0000
Message-ID: <84t83l$hr8$1_at_kermit.esat.net>
Date: Tue, 4 Jan 2000 16:44:22 -0000
Message-ID: <84t83l$hr8$1_at_kermit.esat.net>
[Quoted] 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 - 17:44:22 CET