logging-log4j-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Stauffer <jstau...@spscommerce.com>
Subject RE: oracle.sql
Date Fri, 14 May 2004 11:14:07 GMT
I just tries it in SQL*Plus and it works for me.  Go figure. :-)

James Stauffer


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


Yes, works fine for me.  Try creating it using SQL*Plus.  SQLNavigator
parses it OK as well.  (It is certainly valid SQL).

Simon
> -----Original Message-----
> From:	James Stauffer [SMTP:jstauffe@spscommerce.com]
> Sent:	Friday, 14 May 2004 10:08 AM
> To:	'Log4J Developers List'
> Subject:	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:=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 
> 


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

Mime
View raw message