SQL Developer

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.

SDCLI Cart: How can I enter password automatically?

User_JHFBUJul 4 2022 — edited Jul 4 2022

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:
Scheduling Oracle Exports Using SQL Developer's Cart (CLI) (0 Bytes)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?

This post has been answered by thatJeffSmith-Oracle on Jul 5 2022

Jump to Answer

Added on Jul 4 2022

#data, #export, #oracle, #sql-developer

4 comments

760 views

1 mention