XXOBJPY Project is a tool to extract DDL scripts form a object list. This Project is written in those technologies bellow:

• PL/SQL : the main algorithm to extract object scripts as CLOB.
• Python2 : the main UI to read config fle/object list, generate ourput scripts as zip files.
• cx_oracle: use to connect db and handle sql objects.

• Maintain object lists, and extract those scripts anytime.
• Support for table/view/trigger/index/package/java source.
• Support for fndload scripts.
• Support to create scripts with config file.
• Group objects with owner, code name, and zip to a file.

##Requirements and Setup

• Python2.x:
  https://www.python.org/downloads/
• cx_oracle:
  http://cx-oracle.sourceforge.net/
• Oracle Clinet:
  http://www.oracle.com/technetwork/topics/winsoft-085727.html
  e.g. instantclient-basic-nt-11.2.0.2.0.zip (http://www.oracle.com/technetwork/topics/winsoft-085727.html), Unzip the file, and move it to C:\Python27\instantclient_11_2
• System Varaiables:
  (1). Add System Varaible named ORACLE_HOME, e.g. C:\OracleD10G, this is for locate the TNSNAMES.ORA.
  Or use the command : set ORACLE_HOME=C:\OracleD10G
  (2). Add Oracle Clinet which downloaded before to System Variable PATH
  Or use the command : set PATH=C:\Python27\instantclient_11_2;%PATH%
  

##Run the Program

• put xxGenDDLMain.py and xxobj.py in the same folder and then execute xxGenDDLMain.py
  python xxGenDDLMain.py