PL/SQL developers spend lots of time writing the same kind of code over and over again, much of it based on the underlying tables, views and programs with which we are working.  To save time, we frequently take a "quick and dirty" approach, which is often incomplete and error-prone.

QCGU offers a new approach: choose a template from the QCGU repository (or build your own) that reflects the pattern of code you want to write. Then run that template for a particular database object (usually a table or a program). QCGU will then generate the code in a fraction of the time you would need to write it yourself.

You can think of QCGU as a "design pattern factory," allowing you to generate virtually any sort of code you want (not just Oracle PL/SQL!). But of course most developers aren't going to sit around writing patterns. You will most likely take advantage of QCGU in one of the following ways:

1. Generate table API packages (packages that contain procedures and functions that perform most commonly-needed SQL operations). Specifically, QCGU generated three packages: the Change Package ([tablename]_cp) to perform DML; the Query Package ([tablename]_qp) to perform queries; and the Type Package ([tablename]_tp) to provide pre-defined declaration types. You then call the appropriate program in your application code and skip writing the SQL!
    
2. Utilize the QCGU error management framework. QCGU utilizes in its table API packages a standard error management package named qd_runtime, which in turn writes to the log table (qd_log) and error tables (qd_err_instance and qd_context). You can use this same generalized error management framework in your own applications.

Quest CodeGen Utility is a freeware product.  Quest Support does not support this product.  Instead, users of CodeGen will provide support for each other.

Quest Software is providing a very fine discussion forum as part of its Quest CodeGen Utility community that is available for users of the product.  So please visit the community and then press the "Join a discussion" link on the left side of the page to post your question or — even better! — answer a question or two.

You currently do not have to register in order to post or reply on the forums.  That may change, and we encourage you to register so that you can take full advantage of this and other Quest Software on-line communities and resources.