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:[EMAIL PROTECTED]]
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:[EMAIL PROTECTED]
> Sent: Thursday, 13 May 2004 6:47 AM
> To: '[EMAIL PROTECTED]'
> 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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
