Oracle problem

From: Bart Kelsey (bart_at_osc.edu)
Date: 11/23/04 

Date: Tue, 23 Nov 2004 22:13:30 +0000
To: dbi-users@perl.org

I'm having some trouble with DBD::Oracle...

When I execute this code:

***

    $sth = $dbh->prepare("select * from abbrev where type = ?");

    $sth->execute("PAYMENT");

    while((@row) = $sth->fetchrow_array) {
      print(join(", ", @row), "\n");
    }
    $sth->finish;

***

... no rows are returned. However, when I execute this code here:

***

    $sth = $dbh->prepare("select * from abbrev where type = 'PAYMENT'");

    $sth->execute();

    while((@row) = $sth->fetchrow_array) {
      print(join(", ", @row), "\n");
    }
    $sth->finish;

***

... it correctly returns a row. Does anyone know what the problem might
be? I'm running DBD::Oracle 1.16 on Redhat Enterprise Linux 3,
accessing Oracle 9.2.0.5.0.

Thanks,
Bart

Relevant Pages

  • Execute SQL problem with Oracle
    ... I have a strange problem that I am having trouble troubleshooting. ... 'Microsoft ODBC Driver for Oracle' connection and based an 'Execute SQL' ...
    (microsoft.public.sqlserver.dts)
  • Re: how to click at a option programatically
    ... >> Trouble is: I'll need the IHTMLElement to execute a 'click', ...
    (microsoft.public.inetsdk.programming.webbrowser_ctl)
  • Re: how to click at a option programatically
    ... > Trouble is: I'll need the IHTMLElement to execute a 'click', ... With sufficient thrust, pigs fly just fine. ...
    (microsoft.public.inetsdk.programming.webbrowser_ctl)
  • Re: DataGridView - TextBoxColumn - background update to data source
    ... trouble... ... thread of the causing code - so if your background worker does something it ... execute on the UI thread. ... attempt to hook up events, and send itself in circles in trying. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Coffeeshop etiquette.
    ... If so, God is in ... trouble too, whenever someone falls off the side of a building. ... "failure to act" may actually make it a crime to step out of the path of someone ... What good is being an executive if you never get to execute anyone? ...
    (alt.usage.english)