Not sure if Discussion is correct place for this question about a possible new tool, but:
Not sure if Discussion is correct place for this question about a possible new tool, but: Do there exist some program that may extract metadata structur of the components involved in communicating with an Oracle database consisting of tables and lots of stored procedures in packages? Writing a TCP/IP based multitier Datasnap DBExpress Datasnap server, coupled up to an Oracle Database server still under development, I need a tool for quality check of all parts of the system now and then. It is easy to make a meta-data export of the database model with ER/Studio, but, for the server, metadata extraction only exists for the client when making the proxy datastructure and not to be exported to Excel/CVS file. I need a tool to produce an excel spreed sheet or CVS file with export of tje tSQLdataset properties of Name of component, commandtext, CommandType, SchemaName, maybe SQLConnection in case more than one is defined and serialized parameter list and for tStoredProc I need the equivalents...