RE: oracle delete has no effect

From: Ron Reidy (Ron.Reidy_at_arraybiopharma.com)
Date: 01/04/05 

Date: Tue, 4 Jan 2005 09:13:55 -0700
To: <liooil@ifrance.com>

Hmmm...

So in Toad, did you commit the transaction before you ran your Perl program?

Have you checked the return from the 'execute' for this statement (this will tell you how many rows were processed)? Can you send the value of the variable $SQL_RESET_MYTABLE?

-----------------
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-----Original Message-----
From: liooil [mailto:liooil@free.fr]
Sent: Tuesday, January 04, 2005 9:04 AM
To: Reidy, Ron
Cc: dbi-users@perl.org
Subject: RE: oracle delete has no effect

OK. This a typo
In real life, the SQL is the same...
But indeed, we can say they have a different behaviour

liooil,

Selon "Reidy, Ron" <Ron.Reidy@arraybiopharma.com>:

> The SQL in your '...cool sql editor' and your DBI are different!
>
> -----------------
> Ron Reidy
> Lead DBA
> Array BioPharma, Inc.
>
>
> -----Original Message-----
> From: liooil [mailto:liooil@free.fr]
> Sent: Tuesday, January 04, 2005 8:31 AM
> To: dbi-users@perl.org
> Subject: oracle delete has no effect
>
>
>
> hello world
>
> I'm pretty new to make Oracle and perl together.
>
> I test a very simple request with TOAD and its cool sql editor :
>
> delete from MYTABLE where (NAME<>'UNKNOWN' and ID=123);
>
> Simple, isn't it ? Morever, it works ... What i want to be deleted is
> deleted!
>
>
> I face a strange behaviour when i try to port this request to a perl script :
>
> -------------
> my $SQL_RESET_MYTABLE=
> "delete from $MYTABLE
> where (
> $MY_TABLE_NAME='UNKNOWN'
> and
> $MY_TABLE=123
> )";
> $requete = $SQL_RESET_MYTABLE;
> @result=();
> @result = BdCustom::InsertUpdateLineTableDb($requete, $DBH) ;
> ---------
> Note that BdCustom::InsertUpdateLineTableDb
> is an extra layer over $DBH->do($request, {}, @param );
> to make easy debug and trace ...
> With this sample @param is null of course.
>
> No oracle errors, but nothing deleted neither ...
>
> i thought about special characters in my request but it seems not.
> Other ideas? Any clue?
>
> I'm working with :
> - oracle 9i
> - ActivePerl 5.8
> - DBD-Oracle9 [1.16] from http://ftp.esoftmatic.com/DBI/
>
>
> liooil,
>
> This electronic message transmission is a PRIVATE communication which
> contains
> information which may be confidential or privileged. The information is
> intended
> to be for the use of the individual or entity named above. If you are not the
> intended recipient, please be aware that any disclosure, copying,
> distribution
> or use of the contents of this information is prohibited. Please notify the
> sender of the delivery error by replying to this message, or notify us by
> telephone (877-633-2436, ext. 0), and then delete it from your system.
>
>

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. Please notify the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

Relevant Pages

  • RE: make problem
    ... Perl may be copied only under the terms of either the Artistic License or the ... This electronic message transmission is a PRIVATE communication which contains information ... If you are not the intended recipient, please be aware that any disclosure, ... Please notify the sender ...
    (perl.dbi.users)
  • RE: Insights into DBI->connect differences
    ... You also should set your oracle environment using the shell script ... the sender of the delivery error by replying to this message, or notify ... This electronic message transmission is a PRIVATE communication which contains ... intended recipient, please be aware that any disclosure, copying, distribution ...
    (perl.dbi.users)
  • RE: Connect to Oracle
    ... Subject: Connect to Oracle ... This electronic message transmission is a PRIVATE communication which ... Please notify the sender of the delivery ... intended recipient, please be aware that any disclosure, copying, ...
    (perl.dbi.users)
  • Re: Connect to Oracle
    ... Subject: Connect to Oracle ... This electronic message transmission is a PRIVATE communication which ... Please notify the sender of the delivery ... intended recipient, please be aware that any disclosure, copying, ...
    (perl.dbi.users)
  • RE: make problem
    ... What version **exactly** of Oracle ... Perl may be copied only under the terms of either the Artistic License or the ... If you are not the intended recipient, please be aware that any disclosure, ... Please notify the sender ...
    (perl.dbi.users)