Oh, it works, just have some "features".... like if you have a column_name that is longer than 28 characters, the package will be created but with an error. They decided to just keep the names to less than 27 characters in length so I didn't deal with the "feature" I need to create a generator for audit tables and triggers for myself now as the other - choke, gag, DBA that I work with can't seem to add in the new columns to the audit tables and triggers. Seems he is just to busy... And Mladen Gogala may I suggest my second options which would help you burn off the calories ;) Kathy -----Original Message----- From: Jamadagni, Rajendra [mailto:Rajendra.Jamadagni@xxxxxxxx] Sent: Tuesday, April 27, 2004 8:44 AM To: oracle-l@xxxxxxxxxxxxx Subject: RE: 10G New Features Book - OT Kathy, Lookup "utplsql" at sourceforge.net, if you don't have time to test yourself ... That's exactly what it has been designed for. I don't have much experience with it. Raj ------------------------------------------------------------------------ --------=20 Rajendra dot Jamadagni at nospamespn dot com=20 All Views expressed in this email are strictly personal.=20 select standard_disclaimer from company_requirements;=20 QOTD: Any clod can have facts, having an opinion is an art ! -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Duret, Kathy Sent: Tuesday, April 27, 2004 9:39 AM To: 'oracle-l@xxxxxxxxxxxxx' Subject: RE: 10G New Features Book - OT And so I post something of value. I did get my insert, update, delete, select package generator done. It is not that pretty but it works with a few caveats (long names not dealt with etc.) If anyone is interested feel free to email me directly and I will send it to you. I am going to work on another generator using rowtype that Rajendra Jamadagni suggested I should try. Kathy Duret=20 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- This transmission contains information solely for intended recipient and may be privileged, confidential and/or otherwise protect from disclosure. If you are not the intended recipient, please contact the sender and delete all copies of this transmission. This message and/or the materials contained herein are not an offer to sell, or a solicitation of an offer to buy, any securities or other instruments. The information has been obtained or derived from sources believed by us to be reliable, but we do not represent that it is accurate or complete. Any opinions or estimates contained in this information constitute our judgment as of this date and are subject to change without notice. Any information you share with us will be used in the operation of our business, and we do not request and do not want any material, nonpublic information. Absent an express prior written agreement, we are not agreeing to treat any information confidentially and will use any and all information and reserve the right to publish or disclose any information you share with us. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------