This discussion is archived
0 Replies Latest reply: Mar 20, 2013 4:29 AM by 911604 RSS

Generate connections.xml using only sql commands

911604 Newbie
Currently Being Moderated
Hello,

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,

Frank

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points