Worked on a "100% generated" application on very similar versions you state. Although I used the term 100% in quotes, I was very impressed with the developers - who got about 95% of the gui (screens, reports) done purely through Designer.
Table API's were used primarily for the journalling feature. Worked fine - the only real pain being that any references to CG_REF_CODES in the validation code were done with literals - so heaps of parsing with sql's that could for all intensive purposes be common. You'll your shared pool littered with select .. from cg_ref_codes where domain = some_literal_in_quotes and ... I raised an enhancement with Oracle, but as at 6i.2 (the last time I looked at Designer) it was still the same. hth connor --- "Pardee, Roy E" <[EMAIL PROTECTED]> wrote: > Greetings all, > > Is anyone out there using Oracle Designer's Table > API? We're trying to > decide whether to use it as opposed to writing our > own packages & triggers > (for things like populating sequence-generated PKs, > upcasing VARCHARs, > enforcing domains, etc.). > > From my (admittedly selfish) perspective, any > working line of code that I > don't have to write/support is a good line of code, > but it does look like a > *lot* of code to do not so very much. Our DBA is > concerned that it's > creating unnecessary triggers, will suck down > resources unecessarily, server > will grind to a halt, etc. > > My concern is that we'll find out that the TAPI > procs are bulky & > complicated for a reason--we'll decide to chuck them > & then wind up > reinventing them (and maybe not as well as the folks > at Oracle). Has > anybody out there been over this ground & care to > make a reccomendation? > > Thanks! > > -Roy > > P.S. In case it's important, we're using Designer > 6.0 to create OAS-deployed > Oracle Forms & Reports to run against a 9i db. > > Roy Pardee > Programmer/Analyst > SWFPAC Lockheed Martin IT > Extension 8487 > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Pardee, Roy E > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California -- Public Internet > access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). ===== Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
