Return-Path: Delivered-To: apmail-logging-log4j-dev-archive@www.apache.org Received: (qmail 3564 invoked from network); 14 May 2004 00:10:08 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 14 May 2004 00:10:08 -0000 Received: (qmail 73338 invoked by uid 500); 14 May 2004 00:10:36 -0000 Delivered-To: apmail-logging-log4j-dev-archive@logging.apache.org Received: (qmail 73006 invoked by uid 500); 14 May 2004 00:10:34 -0000 Mailing-List: contact log4j-dev-help@logging.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Log4J Developers List" Reply-To: "Log4J Developers List" Delivered-To: mailing list log4j-dev@logging.apache.org Received: (qmail 72983 invoked by uid 98); 14 May 2004 00:10:34 -0000 Received: from jstauffe@spscommerce.com by hermes.apache.org by uid 82 with qmail-scanner-1.20 (clamuko: 0.70. Clear:RC:0(12.47.34.254):. Processed in 0.216117 secs); 14 May 2004 00:10:34 -0000 X-Qmail-Scanner-Mail-From: jstauffe@spscommerce.com via hermes.apache.org X-Qmail-Scanner: 1.20 (Clear:RC:0(12.47.34.254):. Processed in 0.216117 secs) Received: from unknown (HELO int1.stp.spscommerce.net) (12.47.34.254) by hermes.apache.org with SMTP; 14 May 2004 00:10:33 -0000 Received: from spsc-exchange.spscommerce.com (spsc-exchange.stp.spscommerce.net [172.16.0.7]) by int1.stp.spscommerce.net (Postfix) with ESMTP id 23157CBCE0 for ; Thu, 13 May 2004 19:08:27 -0500 (CDT) Received: by spsc-exchange.spscommerce.com with Internet Mail Service (5.5.2657.72) id ; Thu, 13 May 2004 19:08:26 -0500 Message-ID: From: James Stauffer To: 'Log4J Developers List' Subject: RE: oracle.sql Date: Thu, 13 May 2004 19:08:25 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C43947.0A75B426" X-Spam-Rating: hermes.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N ------_=_NextPart_001_01C43947.0A75B426 Content-Type: text/plain; charset="iso-8859-1" I would get a parse error when I tried to run it without the variable. It might have been the tool I was using (Benthic Golden32), but I couldn't get it to work without the variable. If it works for you without the variable then I can do more research into why it isn't working for me. -----Original Message----- From: Simon Dorrat [mailto:simon.dorrat@gsjbw.com] Sent: Thursday, May 13, 2004 7:02 PM To: 'Log4J Developers List' Subject: RE: oracle.sql What was the error? You should not need a variable - the following code should work fine. SELECT logging_event_id_seq.NEXTVAL INTO :new.event_id FROM dual Doesn't make that much difference, but simpler is better! Simon > -----Original Message----- > From: James Stauffer [SMTP:jstauffe@spscommerce.com] > Sent: Thursday, 13 May 2004 6:47 AM > To: 'log4j-dev@logging.apache.org' > Subject: oracle.sql > > One more update to the trigger. I couldn't get it to work without the > variable. I am not familiar with triggers very much but our app uses a > lot of them so I have a lot of examples that are very close to this. > Basically, I don't know if this is the best way but it seems to work well. > > CREATE TRIGGER logging_event_id_seq_trig > BEFORE INSERT ON logging_event > FOR EACH ROW > declare l_newpk logging_event.event_id%type; > BEGIN > SELECT logging_event_id_seq.NEXTVAL > INTO l_newpk > FROM DUAL; > :new.event_id:=l_newpk; > END logging_event_id_seq_trig; > / > > James Stauffer > Goldman Sachs JBWere Disclosure of Interest ORG: Goldman Sachs JBWere and/or its affiliates expect to receive or intend to seek compensation for financial and advisory services in the next 3 months from the company, its parent, or its wholly owned or majority owned subsidiary. GOLDMAN SACHS JBWERE PTY LTD DISCLAIMER Goldman Sachs JBWere Pty Ltd and its related entities distributing this document and each of their respective directors, officers and agents ("the Goldman Sachs JBWere Group") believe that the information contained in this document is correct and that any estimates, opinions, conclusions or recommendations contained in this document are reasonably held or made as at the time of compilation. However, no warranty is made as to the accuracy or reliability of any estimates, opinions, conclusions, recommendations (which may change without notice) or other information contained in this document and, to the maximum extent permitted by law, the Goldman Sachs JBWere Group disclaims all liability and responsibility for any direct or indirect loss or damage which may be suffered by any recipient through relying on anything contained or omitted from this document. Goldman Sachs JBWere does not represent or warrant the attached files are free from computer viruses or other defects. The attached files are provided, and may only be used, on the basis that the user assumes all responsibility for any loss, damage or consequence resulting directly or indirectly from use. --------------------------------------------------------------------- To unsubscribe, e-mail: log4j-dev-unsubscribe@logging.apache.org For additional commands, e-mail: log4j-dev-help@logging.apache.org ------_=_NextPart_001_01C43947.0A75B426 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: oracle.sql

I would get a parse error when I tried to run it = without the variable.  It might have been the tool I was using = (Benthic Golden32), but I couldn't get it to work without the = variable.  If it works for you without the variable then I can do = more research into why it isn't working for me.

-----Original Message-----
From: Simon Dorrat [mailto:simon.dorrat@gsjbw.com= ]
Sent: Thursday, May 13, 2004 7:02 PM
To: 'Log4J Developers List'
Subject: RE: oracle.sql


What was the error?  You should not need a = variable - the following code
should work fine.

        SELECT  logging_event_id_seq.NEXTVAL
            INTO :new.event_id
           FROM dual

Doesn't make that much difference, but simpler is = better!

Simon


> -----Original Message-----
> From: James Stauffer = [SMTP:jstauffe@spscommerce.com]
> Sent: Thursday, 13 May 2004 6:47 AM
> To:   = 'log4j-dev@logging.apache.org'
> Subject:      = oracle.sql
>
> One more update to the trigger.  I = couldn't get it to work without the
> variable.  I am not familiar with triggers = very much but our app uses a
> lot of them so I have a lot of examples that = are very close to this.
> Basically, I don't know if this is the best way = but it seems to work well.
>
> CREATE TRIGGER logging_event_id_seq_trig =
>   BEFORE INSERT ON logging_event =
>   FOR EACH ROW
>   declare l_newpk = logging_event.event_id%type;
>   BEGIN
>     SELECT = logging_event_id_seq.NEXTVAL
>     INTO   = l_newpk
>     FROM   DUAL; =
>     = :new.event_id:=3Dl_newpk;
>   END logging_event_id_seq_trig; =
> /
>
> James Stauffer
>


Goldman Sachs JBWere
Disclosure of Interest
ORG:  Goldman Sachs JBWere and/or its = affiliates expect to receive or intend to seek compensation for = financial and advisory services in the next 3 months from the company, = its parent, or its wholly owned or majority owned = subsidiary.



GOLDMAN SACHS JBWERE PTY LTD DISCLAIMER

Goldman Sachs JBWere Pty Ltd and its related entities = distributing this document and each of their respective directors, = officers and agents ("the Goldman Sachs JBWere Group") = believe that the information contained in this document is correct and = that any estimates, opinions, conclusions or recommendations contained = in this document are reasonably held or made as at the time of = compilation.  However, no warranty is made as to the accuracy or = reliability of any estimates, opinions, conclusions, recommendations = (which may change without notice) or other information contained in = this document and, to the maximum extent permitted by law, the Goldman = Sachs JBWere Group disclaims all liability and responsibility for any = direct or indirect loss or damage which may be suffered by any = recipient through relying on anything contained or omitted from this = document.

Goldman Sachs JBWere does not represent or warrant = the attached files are free from computer viruses or other = defects.  The attached files are provided, and may only be used, = on the basis that the user assumes all responsibility for any loss, = damage or consequence resulting directly or indirectly from = use.


---------------------------------------------------------------= ------
To unsubscribe, e-mail: = log4j-dev-unsubscribe@logging.apache.org
For additional commands, e-mail: = log4j-dev-help@logging.apache.org

------_=_NextPart_001_01C43947.0A75B426--