Search code examples
oracle-sqldevelopersqlcl

Connect Oracle database with SQLcl

I am using sqldeveloper to query database and export results to csv file. I need this file on daily basis so thought of creating bat file which can be scheduled on windows task scheduler. I was researching it and found I can use SQLcl to run my script to export the query data. But somehow I can't connect it and it gives me and error 'ORA-01017: invalid username/password;logon denied. Here is my connection properties from sql developer

enter image description here

Here is my command line:

sql testuser1/[email protected]:1521/tst.internal

I have java development kit installed

enter image description here

Do I need anything for java? Or do I need any special rights to run sql command line?

Solution

  • Found the problem, my userid is in double quotes so I have to use escape sequence **\**, its working like a charm.