Re: How can I execute a function from within SQL/PLUS

From: Frans Hovenkamp <Dieze_at_popin.nl>
Date: Wed, 26 May 1999 08:52:04 +0200
Message-ID: <7ig5m2$1ab$1_at_zonnetje.NL.net>


Try this one: SELECT west_requirement_apr_fn(107,sysdate) FROM dual; Frans

change heeft geschreven in bericht <7if3v5$hlk1_at_kcweb01.netnews.att.com>...
>From the Sql/plus prompt(>) I attempt the following:
>
> SQL> exec west_requirement_apr_fn(107,sysdate);
> begin west_requirement_apr_fn(107,sysdate); end;
>
> *
> ERROR at line 1:
> ORA-06550: line 1, column 7:
> PLS-00221: 'WEST_REQUIREMENT_APR_FN' is not a procedure or is undefined
> ORA-06550: line 1, column 7:
> PL/SQL: Statement ignored
>
>I know that somehow I should do something like this:
>
> varchar2 result;
> result = west_requirement_apr_fn(107,sysdate);
>
>Can anyone help me with the proper format to call a function from the
>command line?
>
>Thanks,
>
>Wayne Weiselogel
>
>
Received on Wed May 26 1999 - 08:52:04 CEST

Original text of this message