Result of a function executing a command

From: Antony Giblin <agiblin_at_software-resource.com>
Date: Wed, 25 Aug 1999 15:30:37 +0100
Message-ID: <935592270.2891.0.nnrp-02.c2de09a4@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);
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 !!

Cheers
Tony Giblin. Received on Wed Aug 25 1999 - 09:30:37 CDT