Skip to Main Content

SQLcl

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SQLCl Command line issue

Aasubram-OracleOct 25 2017 — edited Oct 25 2017

Hi,

Can someone help me with this?

The issue is with SQLDeveloper version 17.2.0.188 Build 188.1159

“trying to run sqldeveloper report from command line .

it errors with:

  1. java.lang.IllegalArgumentException: null connection not allowed

it works fine from the gui and I saved password in the connection.

When I check the environment variable APPDATA is set to C:\users\myusername\AppData\Roaming

I see the connections.xml file under there under the sql developer folder

Is there another environment variable I need to set so it can find the connections.xml file?”

The command used is

sdcli64.exe reports generate -report "Invalid Objects" -db "TEST" -file "C:\TEMP\output.html"

Executed at the OS cmd window as the same OS user through which he runs the SQLDeveloper GUI as well. It does not work.

Customer has the following questions

what file is it looking in for the connections?
connections.xml?
tnsnames.ora?
Please let me know and I can check the files.
Also what path paths does it look in?

Kindly let me know if I am missing something on this.

Thanks,

Anand

Comments

Post Details

Added on Oct 25 2017
1 comment
365 views