Created
September 28, 2015 00:56
-
-
Save tschf/0e75f798c5b6be79ef21 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$ /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