How can I execute a function from within SQL/PLUS
From: change <changeme_at_changeme>
Date: Tue, 25 May 1999 16:23:34 -0500
Message-ID: <7if3v5$hlk1_at_kcweb01.netnews.att.com>
From the Sql/plus prompt(>) I attempt the following:
PL/SQL: Statement ignored
Date: Tue, 25 May 1999 16:23:34 -0500
Message-ID: <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 Tue May 25 1999 - 23:23:34 CEST