SQL*Plus (MOSC)

MOSC Banner

SQLPLUS variable definition within executed file

A moderately frustrating thing, found recently when trying to set up a batch file that causes a SQLPLUS script to run. Specifically, most of the material works just fine, but an important catch has to do with the SQLPLUS DEF/DEFINE preprocessor-esque functionality. The batch file does what it's supposed to and starts the script. The script's logic is sound. However, the script also prompts for the user to provide the &-marked values at runtime, which is specifically NOT what is desired. Text of files is as below. (login is done via external identification)


batch_runner.bat:

sqlplus /@service_id @batch_runner.sql

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center