Returning blob in sql

From: Perldiscuss - Perl Newsgroups And Mailing Lists (rc264_at_cornell.edu)
Date: 05/18/04

  • Next message: Tim Bunce: "Re: solved!" 
    Date: 18 May 2004 04:03:51 -0000
To: dbi-users@perl.org

    Hi,
    Can you tell me why
    "Insert into Foo values (?, EMPTY_BLOB()) returning data into ?"
    causes a segmentation fault.
    Where Foo is create table Foo (id integer, data blob);

    The section of the code that runs this sql statement is
    $stmt = "INSERT INTO Foo VALUES (?, EMPTY_BLOB()) returning the_file into
    ?";
    $sth = $dbh->prepare($stmt);
    $sth->bind_param(1, $id);
    $sth->bind_param_inout(2, \$loc, 1000, {ora_type => ORA_BLOB});
    $sth->execute or die $dbh->errstr;

    My perl/oracle/os/machine config is as follows:
    Perl: 5.8.3
    Oracle: 9i2
    OS: GNU/Linux
    Kernel: 2.4.18-14
    machine: i686
    processor: i686
    hardware platform: i386

    Any hints appreciated..

    Much thanks
    Raj

  • Next message: Tim Bunce: "Re: solved!"

    Relevant Pages

    • Re: Typecast problem in PHP 5.0.4
      ... A segmentation fault is normally a bug in the PHP interpreter or some ... class Foo{ ...
      (comp.lang.php)
    • Re: Recursive weakness ?!
      ... > $ foo() ... Shells prevents this type of never-ends loop with aliases. ... Because recursion is a useful technique in functions, ...
      (comp.unix.shell)
    • Recursive weakness ?!
      ... $ foo() ... Segmentation fault ... foo function is recursive and never-ends... ... Shells prevents this type of never-ends loop with aliases. ...
      (comp.unix.shell)
    • gvinum looses drives
      ... gvinum -> list ... Jun 19 12:25:39 current kernel: FOO: sd raid5.p0.s3 is up ... Jun 19 12:26:47 current kernel: FOO: plex mp3dev.p0 is down ...
      (freebsd-current)
    • Re: Compiling C++ modules
      ... Without exceptions (which are fragile in a kernel), the former can't return an error instead of initializing the Foo. ... Foo item1, item2; ...
      (Linux-Kernel)