<[EMAIL PROTECTED]>
Sent: Tuesday, June 03, 2003 2:02 PM
Subject: RE: DBI and Unique Keys
> [Mark: please post only plain text, and don't top-post. I've moved your
> reply to the bottom]
>
> Mark Martin wrote:
> > - Original Message -
> > From: "
MAIL PROTECTED]>
> Sent: Monday, June 02, 2003 2:14 PM
> Subject: RE: DBI and Unique Keys
>
>
> > Mark Martin wrote:
> > > Hi,
> > > I have an Oracle table with a Unique Key which is generated by a
> > > trigger :
> > >
> >
use DBI;use DBD::Oracle;
is redundant
use DBI;
is sufficient.
José.
> -Original Message-
> From: Mark Martin [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 03, 2003 12:47 PM
> To: Bob Showalter; [EMAIL PROTECTED]
> Subject: Re: DBI and Unique Keys
>
>
> Bob,
ect(); exit;
----- Original Message -
From: "Bob Showalter" <[EMAIL PROTECTED]>
To: "'Mark Martin'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, June 02, 2003 2:14 PM
Subject: RE: DBI and Unique Keys
> Mark Martin wrote:
> >
Mark Martin wrote:
> Hi,
> I have an Oracle table with a Unique Key which is generated by a
> trigger :
>
> CREATE TRIGGER MYTRIGGER
> before insert on MYTABLE
> for each row
> begin
> select MYSEQUENCE.nextval into :new.MYCOLUMNAME from dual; end;
> And this works fine on normal insert
>
> When
Mark Martin wrote:
> Hi,
> I have an Oracle table with a Unique Key which is generated by a trigger :
>
> CREATE TRIGGER MYTRIGGER
> before insert on MYTABLE
> for each row
> begin
> select MYSEQUENCE.nextval into :new.MYCOLUMNAME from dual;
> end;
> And this works fine on normal insert
>
> When I
Hi,
I have an Oracle table with a Unique Key which is generated by a trigger :
CREATE TRIGGER MYTRIGGER
before insert on MYTABLE
for each row
begin
select MYSEQUENCE.nextval into :new.MYCOLUMNAME from dual;
end;
And this works fine on normal insert
When I try to insert from a perl script I get
