Lattice.SPGen is a stored procedure generator that
supports Microsoft SQL Server, Oracle and IBM DB2
UDB. Lattice.SPGen will process each table and view
in the database which you selected and created stored
procedures to insert, update, delete, select (single
or multiple records) using the fields you choose as
well as using stored procedure’s name you desire.
Below is how it works:

1. Collect metadata from different datasource
(Oracle, DB2, SQL Server)
2. Build xml metadata input definition file
3. Generate stored procedures using xslt with
different xsl stlysheet.

Features added in version 1.3

* Option to generate business entity class per
table
* Option to generate one big sql script file or
each file per table
* Option to generate XML metadata definition file

Main features:

* Control output stored procedures format in runtime
by modifying XSL style sheet.
* Change stored procedure’s name, exclude stored
procedure’s columns on the fly.
* Auto-generate package header and body for Oracle.
* Auto-generate stored procedures to insert data rows
and return identity id for SQL server and sequence
number for Oracle.
* Auto-generate stored procedures to select, update,
delete single data row based on primary key
definitions.
* Auto-generate stored procedures to select all rows
based on foreign key definitions.
* Auto-generate stored procedures to select all rows
of tables and views.
* Support composite primary key

Lattice.SPGen 1.3 supports the following RDBMS:
* MS SQL Server 2000 and 7, MSDE 2000.
* Oracle 8i and 9i.
* IBM DB2 UDB

Below is the link to download the software:
http://www.latticesoft.com/DesktopDefault.aspx?
tabindex=4&tabid=13


Lattice Business Software
http://www.latticesoft.com

Download (235 KB) Website Link to this page