view release on metacpan or  search on metacpan

Changes  view on Meta::CPAN

  are taking on the role of lead maintainer - with my support and gratitude.
  John Scoles at pythian.com is now the man in the hot seat for support and
  maintenance!

  Fixed automatic csform setting for some UTF8 cases and for Oracle 8.0
  Fixed truncation error on fetch into UTF8 charset thanks to Honza Pazdziora.
  Fixed INTERVAL DAY TO SECOND thanks to Honza Pazdziora.
  Fixed unicode tests for cygwin thanks to Andy Hassall.
  Fixed undef warnings when connecting with undef $user.
  Fixed undef warnings from $dbh->get_info(18);
  Fixed LOB streaming example thanks to Pablo Zorzoli.

  Added support for nested cursors in select lists thanks to Charles Jardine.
  Added "Trailing Spaces" section to docs thanks to Michael A Chase.
  Added support for binary floats/doubles thanks to Dennis Box.
  Added INSTANCE_NAME, SERVER and SERVICE_NAME as valid connect keywords
    in the 'dbi:Oracle:x=y' short form of connecting without tnsnames.ora.
    For example 'dbi:Oracle:host=localhost;service_name=xe;server=dedicated'
  Added auto-detection of ORACLE_HOME in some configurations.

  Changed "Binding Cursors" docs, clarifying examples thanks to Charles Jardine.

README.mkdn  view on Meta::CPAN

    my $offset = 100234;
    my $data = "This string will overwrite a portion of the blob";
    $dbh->ora_lob_write( $bin_locator, $offset, $data );

After running this code, the row where lob\_id = 5 will
contain, starting at position 100234 in the bin\_data column,
the string "This string will overwrite a portion of the blob".

### Example: Streaming character data from the database

In this example, we demonstrate a technique for streaming
data from the database to a file handle, in this case
STDOUT.  This allows more data to be read in and written out
than could be stored in memory at a given time.

    my $lob_id = 17;   # Arbitrary row identifier, for example

    $sth = $dbh->prepare( <<"   SQL", { ora_auto_lob => 0 } );
       SELECT chardata
       FROM lob_example
       WHERE lob_id = ?

lib/DBD/Oracle.pm  view on Meta::CPAN

   my $offset = 100234;
   my $data = "This string will overwrite a portion of the blob";
   $dbh->ora_lob_write( $bin_locator, $offset, $data );

After running this code, the row where lob_id = 5 will
contain, starting at position 100234 in the bin_data column,
the string "This string will overwrite a portion of the blob".

=head3 Example: Streaming character data from the database

In this example, we demonstrate a technique for streaming
data from the database to a file handle, in this case
STDOUT.  This allows more data to be read in and written out
than could be stored in memory at a given time.

   my $lob_id = 17;   # Arbitrary row identifier, for example

   $sth = $dbh->prepare( <<"   SQL", { ora_auto_lob => 0 } );
      SELECT chardata
      FROM lob_example
      WHERE lob_id = ?