Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Cannot create Trigger, won't show me errors

Re: Cannot create Trigger, won't show me errors

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Tue, 18 Oct 2005 07:02:01 -0700
Message-ID: <rISdnYIO1pfZncjeRVn-gg@comcast.com>

"Marian Aldenhövel" <marian_at_mba-software.de> wrote in message news:dj2eop$k0f$3_at_newsreader3.netcologne.de... Hi,

> You're aware of sequence.currval?

Yes.

But I need to support several databases. And looking at them in parallel it is easier to generate-key-then-insert than to insert-then-get-generated-key.

Plus: If i stick to one of the two ways to do it the client-code looks the same for all DBs supported. Only the method for key-generation is different. I like it.

Ciao, MM

-- 
Marian Aldenhövel, Rosenhain 23, 53123 Bonn. +49 228 624013.
http://www.marian-aldenhoevel.de
"And starting today all passwords must contain letters, numbers,
  doodles, sign language and squirrel noises." http://tinyurl.com/csu7p

Ugh, not this crap again.  Typical unscalable lowest common denominator
solution.
Received on Tue Oct 18 2005 - 09:02:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US