Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Result of a function executing a command
Try using a PL/SQL block, i.e.
VAR result VARCHAR2
BEGIN
:result := PROCEDURE_10111 (parameters);
IF :result = 'equality test' then PROCEDURE2; END IF;
END;
Antony Giblin <agiblin_at_software-resource.com> wrote in message
news: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:10:10 CDT