in reply to Invalid buffer?

You sure you opened your file correctly?

Being right, does not endow the right to be rude; politeness costs nothing.
Being unknowing, is not the same as being stupid.
Expressing a contrary opinion, whether to the individual or the group, is more often a sign of deeper thought than of cantankerous belligerence.
Do not mistake your goals as the only goals; your opinion as the only opinion; your confidence as correctness. Saying you know better is not the same as explaining you know better.

Replies are listed 'Best First'.
Re^2: Invalid buffer?
by htrobert (Novice) on Jan 14, 2005 at 16:16 UTC
    Yes, it clearly read binary data into the variable.
[reply]
      Try: 
      use DBI qw( :sql_types );

# Lots of code here ...

my $stmt = "INSERT INTO project_figures (pjfg_id, pjfg_name, pjfg_imag
+e) VALUES(:1,:2,:3)";
my $sth  = $dbh->prepare($stmt);

$sth->bind_param( 1, 1 );
$sth->bind_param( 2, 'picture1.wmf' );
$sth->bind_param( 3, 'picture1.wmf', { db2_file => 1 ) );

my $rc = $sth->execute();

      [download]

      Information found at DBD::DB2 link

      Note: I've never used DB2, so I am merely going off the documentation.

      Being right, does not endow the right to be rude; politeness costs nothing.
      Being unknowing, is not the same as being stupid.
      Expressing a contrary opinion, whether to the individual or the group, is more often a sign of deeper thought than of cantankerous belligerence.
      Do not mistake your goals as the only goals; your opinion as the only opinion; your confidence as correctness. Saying you know better is not the same as explaining you know better.

[reply]
[d/l]
        I get the same "invalid output or indicator buffer" message on the last line of your code.
[reply]

In Section Seekers of Perl Wisdom