AnsweredAssumed Answered

Request for a sample database DML/DDL process

Question asked by mkbobba on Sep 26, 2012
Latest reply on Mar 17, 2016 by Andy_Thompson
We are running ITPAM 3.1SP01 on Linux platform and trying to get our feet wet.

With the limited experience we have, we created a process to do the below:

1) Ask user for Database Name, Schema Name, SQL to be run
2) Connect to Oracle database and execute the SQL against the database

But we are not sure if we have built this intelligently using best practices.

Also, we are not happy with the logs we are getting from the process and our ability to pass that to the user.

I appreciate if any one have a process that does things similar to what I have described above.

It will be great if you can share the *.xml file.

Thanks in advance.

Murali Bobba