1 Reply Latest reply: Jul 25, 2013 4:32 PM by Barry Mcgillin-Oracle RSS

    SQLDev4 - sdcli - space in report name (Linux/Mac)

    Vishal Gupta

      SQL Developer Version - 4.0.0.12.27

       

      On linux/Mac platforms, in SQL Developer 4, when using command line interface (sdcli) to generate the html from a "User Defined Report", if report path has space, then it fails. Its due to use of $* in sqldeveloper/bin/sqldeveloper file used to launch the IDE. If parameter are instead passed using "$@", then report name is properly passed to the IDE and it generate the report successfully.

       

      May be SQL Developer developer's might want to fix this bug.

       

      $ grep LaunchIDE sqldeveloper

       

      LaunchIDE $*

       

      $ bash sdcli reports generate -report "Vishal/Statistics Names/Latch Names" -db 11203_RHEL6 -file /tmp/vishal.html

       

      Oracle SQL Developer

      Copyright (c) 1997, 2013, Oracle and/or its affiliates. All rights reserved

       

       

      Jul 25, 2013 4:34:58 PM javax.ide.extension.spi.DefaultElementContext resolveResource

      SEVERE: jar:/file:/Applications/SQLDeveloper.app/Contents/Resources/sqldeveloper/sqldeveloper/extensions/oracle.sqldeveloper.migration.application.jar!/META-INF/extension.xml:16: Resource not found: '${SCRATCH_COMMAND_ICON}'.

      Invalid reports command: -FILE

       

      $ grep LaunchIDE sqldeveloper

       

      LaunchIDE "$@"

       

      $ bash sdcli reports generate -report "Vishal/Statistics Names/Latch Names" -db 11203_RHEL6 -file /tmp/vishal.html

       

      Oracle SQL Developer

      Copyright (c) 1997, 2013, Oracle and/or its affiliates. All rights reserved.

       

       

      Jul 25, 2013 4:35:24 PM javax.ide.extension.spi.DefaultElementContext resolveResource

      SEVERE: jar:/file:/Applications/SQLDeveloper.app/Contents/Resources/sqldeveloper/sqldeveloper/extensions/oracle.sqldeveloper.migration.application.jar!/META-INF/extension.xml:16: Resource not found: '${SCRATCH_COMMAND_ICON}'.

      Success!