Skip to content

Instantly share code, notes, and snippets.

@tschf
Created September 28, 2015 00:56
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tschf/0e75f798c5b6be79ef21 to your computer and use it in GitHub Desktop.
Save tschf/0e75f798c5b6be79ef21 to your computer and use it in GitHub Desktop.
$ /home/trent/node-v0.12.2-linux-x64/bin/node app.js dev 110
options { configFile: '/home/trent/apex-diff/config/config.json',
sqlcl: '/opt/sqlcl/bin/sql',
debug: true,
rebuildTempFile: false,
connections:
{ dev: 'dl_test/dl_test@localhost/xe',
prod: 'dl_prod/dl_prod@localhost/xe' } }
sql: { command: '%SQLCL% %CONNECTION% @%DIRECTORY%/%FILENAME% %PARAMS%',
files:
{ path: '/home/trent/apex-diff/source',
json: { fileName: 'f110.json', data: '' },
apexDiff:
{ fileName: 'apex-diff.sql',
params: '%APP_ID% %SPOOL_FILENAME%' },
generateJson: { fileName: 'temp.sql', params: '%APP_ID%' } } }
arguments: { connectionName: 'dev', appId: '110' }
Validations passed
Time: 0.006s
Setting up sql.command
Rebuilding generateJson file
sql.command: /opt/sqlcl/bin/sql dl_test/dl_test@localhost/xe @/home/trent/apex-diff/source/apex-diff.sql 110 /home/trent/apex-diff/source/temp.sql
Running sql.command
Bad Option: /home/trent/apex-diff/source/temp.sql
Usage 1: sql -H | -V
-H Displays the SQLcl version and the
usage help.
-V Displays the SQLcl version.
Usage 2: sql [ [<option>] [{logon | /nolog}] [<start>] ]
<option> is: [-R <level>] [-S]
-R <level> Sets restricted mode to disable SQLcl commands
that interact with the file system. The level can
be 1, 2 or 3. The most restrictive is -R 3 which
disables all user commands interacting with the
file system.
-S Sets silent mode which suppresses the display of
the SQLcl banner, prompts, and echoing of
commands.
<logon> is: {<username>[/<password>][@<connect_identifier>] | / }
[AS {SYSDBA | SYSOPER | SYSASM}]
Specifies the database account username, password and connect
identifier for the database connection. Without a connect
identifier, SQLcl connects to the default database.
The AS SYSDBA, AS SYSOPER and AS SYSASM options are database
administration privileges.
<connect_identifier> can be in the form of Net Service Name
or Easy Connect.
@[<net_service_name> | [//]Host[:Port]/<service_name>]
<net_service_name> is a simple name for a service that resolves
to a connect descriptor.
Example: Connect to database using Net Service Name and the
database net service name is ORCL.
sql myusername/mypassword@ORCL
Host specifies the host name or IP address of the database
server computer.
Port specifies the listening port on the database server.
<service_name> specifies the service name of the database you
want to access.
Example: Connect to database using Easy Connect and the
Service name is ORCL.
sql myusername/mypassword@Host/ORCL
The /NOLOG option starts SQLcl without connecting to a
database.
<start> is: @<URL>|<filename>[.<ext>] [<parameter> ...]
Runs the specified SQLcl script from a web server (URL) or the
local file system (filename.ext) with specified parameters that
will be assigned to substitution variables in the script.
When SQLcl starts, and after CONNECT commands, the site profile
(e.g. $ORACLE_HOME/sqlplus/admin/glogin.sql) and the user profile
(e.g. login.sql in the working directory) are run. The files may
contain SQLcl commands.
Refer to the SQLDeveloper User's Guide and Reference for more information.
child_process.js:1389
throw err;
^
Error: Command failed: /opt/sqlcl/bin/sql dl_test/dl_test@localhost/xe @/home/trent/apex-diff/source/apex-diff.sql 110 /home/trent/apex-diff/source/temp.sql
Bad Option: /home/trent/apex-diff/source/temp.sql
Usage 1: sql -H | -V
-H Displays the SQLcl version and the
usage help.
-V Displays the SQLcl version.
Usage 2: sql [ [<option>] [{logon | /nolog}] [<start>] ]
<option> is: [-R <level>] [-S]
-R <level> Sets restricted mode to disable SQLcl commands
that interact with the file system. The level can
be 1, 2 or 3. The most restrictive is -R 3 which
disables all user commands interacting with the
file system.
-S Sets silent mode which suppresses the display of
the SQLcl banner, prompts, and echoing of
commands.
<logon> is: {<username>[/<password>][@<connect_identifier>] | / }
[AS {SYSDBA | SYSOPER | SYSASM}]
Specifies the database account username, password and connect
identifier for the database connection. Without a connect
identifier, SQLcl connects to the default database.
The AS SYSDBA, AS SYSOPER and AS SYSASM options are database
administration privileges.
<connect_identifier> can be in the form of Net Service Name
or Easy Connect.
@[<net_service_name> | [//]Host[:Port]/<service_name>]
<net_service_name> is a simple name for a service that resolves
to a connect descriptor.
Example: Connect to database using Net Service Name and the
database net service name is ORCL.
sql myusername/mypassword@ORCL
Host specifies the host name or IP address of the database
server computer.
Port specifies the listening port on the database server.
<service_name> specifies the service name of the database you
want to access.
Example: Connect to database using Easy Connect and the
Service name is ORCL.
sql myusername/mypassword@Host/ORCL
The /NOLOG option starts SQLcl without connecting to a
database.
<start> is: @<URL>|<filename>[.<ext>] [<parameter> ...]
Runs the specified SQLcl script from a web server (URL) or the
local file system (filename.ext) with specified parameters that
will be assigned to substitution variables in the script.
When SQLcl starts, and after CONNECT commands, the site profile
(e.g. $ORACLE_HOME/sqlplus/admin/glogin.sql) and the user profile
(e.g. login.sql in the working directory) are run. The files may
contain SQLcl commands.
Refer to the SQLDeveloper User's Guide and Reference for more information.
at checkExecSyncError (child_process.js:1346:13)
at execSync (child_process.js:1386:13)
at Object.<anonymous> (/home/trent/apex-diff/app.js:130:16)
at Module._compile (module.js:460:26)
at Object.Module._extensions..js (module.js:478:10)
at Module.load (module.js:355:32)
at Function.Module._load (module.js:310:12)
at Function.Module.runMain (module.js:501:10)
at startup (node.js:129:16)
at node.js:814:3
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment