4 Replies Latest reply: Jun 5, 2014 10:30 AM by ERPDude RSS

    SQL Developer 4.0.1.14 Snippets issues

    Gussay

      I have installed SQL Dev 4.0.1.14

      It installed, copied my settings and connections correctly.

       

      I am getting a weird bug from my imported custom snippets though... some (not all) of my custom snippets are converting carriage return values into a comma....

       

      And it is quite random on which snippets it does this to... I have checked the underlying UserSnippets.xml for weird carriage return characters...  but found chr(13) and chr(10) for the snippets that render properly AND for those that don't...

       

      example, the following code :

       

        ALTER USER MY_SCHEMA ACCOUNT UNLOCK;

       

       

      GRANT CREATE SESSION TO MY_SCHEMA;

       

      GRANT CREATE SEQUENCE TO MY_SCHEMA;

      GRANT CREATE TABLE TO MY_SCHEMA;

      GRANT CREATE VIEW TO MY_SCHEMA;

      GRANT CREATE MATERIALIZED VIEW TO MY_SCHEMA;

      GRANT CREATE TRIGGER TO MY_SCHEMA;

      GRANT CREATE PROCEDURE TO MY_SCHEMA;

       

      GRANT CREATE SYNONYM TO MY_SCHEMA;

       

      gets converted to :

       

      , ALTER USER MY_SCHEMA ACCOUNT UNLOCK;, GRANT CREATE SESSION TO MY_SCHEMA;, ,GRANT CREATE SEQUENCE TO MY_SCHEMA;,GRANT CREATE TABLE TO MY_SCHEMA;,GRANT CREATE VIEW TO MY_SCHEMA;,GRANT CREATE MATERIALIZED VIEW TO MY_SCHEMA;,GRANT CREATE TRIGGER TO MY_SCHEMA;,GRANT CREATE PROCEDURE TO MY_SCHEMA;,GRANT CREATE SYNONYM TO MY_SCHEMA;

       

      Any suggestions?

       

      Gus.. (ps, I award points)