0 Replies Latest reply on Mar 20, 2013 11:29 AM by 911604

    Generate connections.xml using only sql commands


      I have a database, where all connection information (Hostname, User, Port, SID, etc.) are stored for several databases. Now I want to create the connections.xml which I can import to the SQL Developer. The idea is to administer the connection information in a single point. Then anyone can query and import the connections easily to the SQL Developer.
      The structure itself was easy to understand and implement using XMLELEMENT. My Problem is, how can I save the password respectively how is the password encrypted? I have found several tools that can decode the password, but I have the plaintext. I found a solution using Jython, but I want to use only SQL. There should be a suitable algorithm in the dbms_crypto package, I hope. I don´t want to use other tools or languages.

      Thanks for help,


      Edited by: frank_nillies on 20.03.2013 04:28
      - renamed connection.xml to connections.xml