(since EVL 2.0)
Run SQL from stdin or
<f_in> and write result into stdout or
<f_out>. It returns
output from ’sqlplus’ as is, so for quering the table to get formatted EVL output use
‘Readora’ or ‘evl readora’.
is to be used in EVS job structure definition file.
<f_out>is either output file or flow name.
- evl runora
is intended for standalone usage, i.e. to be invoked from command line and writing records to standard output.
EVD and EVS are EVL definition files, for details see evl-evd(5) and evl-evs(5).
Runora <f_in> <f_out> [-u|--username=<user>] [-p|--password=<password>] [--connect=<connect_identifier>] evl runora [-u|--username=<user>] [-p|--password=<password>] [--connect=<connect_identifier>] [-v|--verbose] evl runora ( --help | --usage | --version )
print this help and exit
print short usage information and exit
print version and exit
sqlplus will be called in the form:
where <connect_identifier> can be in the form
[<net_service_name> | [//]Host[:Port]/<service_name>]
without this option environment variable ORACONN (if defined) is used as connection identifier for sqlplus
- -p, --password=<password>
without this option environment variable ORAPASS is used as password for sqlplus
- -u, --username=<user>
without this option environment variable ORAUSER is used as user for sqlplus