Forum Stats

  • 3,872,067 Users
  • 2,266,376 Discussions
  • 7,911,043 Comments

Discussions

SDCLI Cart: How can I enter password automatically?

User_JHFBU
User_JHFBU Member Posts: 2 Green Ribbon
edited Jul 4, 2022 2:56PM in SQL Developer

Hi!

I want to export the result of a query to pdf format so I created an sdcart file using Cart in Oracle SQL Developer.

I followed the instructions by this tutorial:

I also created a .bat file because I would like to schedule the running of the export in order to run it every day. So I copied the sdcli command into a batch file which contains this:

c:\

cd c:\Users\{username}\...\sqldeveloper\bin\

start sdcli cart export -cart C:\Users\{username}\...\sqldeveloper\bin\Cart_1.sdcart -config C:\Users\{username}\...\sqldeveloper\bin\export_tool.xml -target C:\Users\{username}\...\sqldeveloper\bin\export_tool.pdf

If I run this batch file, a window appears asking the password of my database connection, so I need to enter it manually (this way the output file can be generated) but it's not the right solution because the batch file should enter the password automatically.

I tried to give the command -pwd <Password> but it couldn't run.

Could you give me some information regarding the solution?

Tagged:

Best Answer

Answers