Re: Result of a function executing a command

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Wed, 25 Aug 1999 17:24:15 +0200
Message-ID: <7q11s5$15k$1@oceanite.cybercable.fr>

Unfortunatly there is no IF statement in SQL*Plus but you can encapsulate in a PL/SQL bloc:

VAR result VARCHAR2
BEGIN
:result:=PROCEDURE_10111 (parameters); IF :result='equality test' then

PROCEDURE2;
END IF;
END;
/

Antony Giblin a écrit dans le message
<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);
>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 - 10:24:15 CDT