From oracle-l-bounce@freelists.org Wed Apr 20 10:30:47 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j3KFUkAs013811 for ; Wed, 20 Apr 2005 10:30:46 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j3KFUk4Z013798 for ; Wed, 20 Apr 2005 10:30:46 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5C9B1185E34; Wed, 20 Apr 2005 09:28:27 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 17213-10; Wed, 20 Apr 2005 09:28:27 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CDBBB185DD2; Wed, 20 Apr 2005 09:28:26 -0500 (EST) Date: Wed, 20 Apr 2005 10:26:35 -0400 (EDT) From: Jeff Herrick X-X-Sender: jherrick@persweb.avalonworks.net To: Paula_Stankus@doh.state.fl.us Cc: oracle-l@freelists.org Subject: RE: branding or versioning forms and reports In-Reply-To: Message-ID: <20050420101626.L68614@persweb.avalonworks.net> References: MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII X-Virus-Status: Clean Content-Transfer-Encoding: 8bit X-archive-position: 18670 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jherrick@igs.net Precedence: normal Reply-To: jherrick@igs.net X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=none autolearn=ham version=2.63 Paula The 'what' command is looking for the magic string '@(#)' so you just need to use a combination of that string and the dynamic string that your source versioning system provides. I have only used VSS, PVCS and RCS but they all have the same concept. I'm sure that SCM can do it too. So in one of your form triggers you would have vers varchar2(2000) := '@(#) $Version'; And then SCM would substitute the version for you. The what comand would work from there. You would only run into a problem if Oracle was doing some hashing/mangling of your strings in the forms binary. =8-0 But I have done this routinely with 'C' executables i.e. static char ident[] = "@(#) $Version"; HTH Jeff Herrick On Wed, 20 Apr 2005 Paula_Stankus@doh.state.fl.us wrote: > We are working with SCM - Oracle's versioning software. We wish to put > in the version in each form so we can do a what on the form binary and > see what version it is. Is this possible? > > We are also trying to use SCCS we can compile a form then check it in > with SCCS but when we check it out we cannot compile again. =20 > > We would prefer to use Oracle's SCM but the issue is with "versioning" > or "branding" the code so we can do a what and easily see what version > the binary is. > > Help? > -- > http://www.freelists.org/webpage/oracle-l > -- http://www.freelists.org/webpage/oracle-l