Re: SQL*Plus: can variables be used for control of execution?

> I run Oracle v.8.1.7, and I am making a script to be run in SQL*Plus several
> times.
> This script should be run by one specific user logged on, and I would like
> to add some functionality to check whether the person starting the script is
> logged on as the user I want her to be, otherwise do not run the commands.
>
> It seems to be possible to use variables in SQL*Plus scripts, so I can
> probably put the name of the current user into a variable. But I would like
> to terminate the script (EXIT) if the content of that variable is not
> identical to one specific value - something like:
> IF VAR1 <> 'SUP'
> EXIT;
> ELSE
> .
> .
> Is it possible in any way to get this functionality into a SQL*Plus script?

Just look at the content of the pre-defined variable USER from inside your PL/SQL block.

Daniel Received on Tue Mar 30 2004 - 10:03:22 CST