Re: Result of a function executing a command

A solution for enemies of PL/SQL

Antony Giblin <agiblin_at_software-resource.com> wrote in article <935592270.2891.0.nnrp-02.c2de09a4_at_news.demon.co.uk>...
: Does anyone know whether it is possible to execute a command in
SQL*Plus,
: based on a result
: of a function. For example :
:
: SQL > VAR result VARCHAR2
: SQL > EXEC :result::=PROCEDURE_10111 (parameters);

col prog nopri new_v prog
set pau off
select decode(:result, 'equality test', 'PROCEDURE_2', 'null') prog  from dual;
exec &&prog

: SQL > IF :result='equality test' then EXEC PROCEDURE 2; << i.e. can
this be
: done in Oracle 7.3 ???
:
: If anyone is also trying to do the same, please let me know and we
may be
: able to help each other !!

--
 Alexander I.Doroshko, aid_at_grant.kharkov.ua

• Bank "Grant", Kharkov, Ukraine