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?