RE: Multiple IN variables for Oracle Procedure

2002-06-14 Thread Southern, Mark R
Hi Bruce, Can you more fully explain your rationale? It sounds like an interesting idea, but that's the first i've heard of it. Thanks, Mark. -Original Message- From: Powell, Bruce [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 11:26 AM To: 'Scott T. Hildreth'; Powell, Bruce C

New Module on CPAN: DBIx::BLOB::Handle

2002-05-15 Thread Southern, Mark R
*Shameless plug* Feedback appreciated. NAME DBIx::BLOB::Handle - Read Database Large Object Binaries from file handles _ SYNOPSIS use DBI; use DBIx::BLOB::Handle; # use DBIx::BLOB::Handle qw( :INTO_STATEMENT ); $dbh = DBI->connect('DBI:Oracle:ORCL','scott','tiger', {Raise

Problem / BUG with blob_read and DBI v1.21 and DBD::Oraclev1.12

2002-04-19 Thread Southern, Mark R
I am trying to read from an oracle CLOB. When i call blob_read with 5 parameters then my script dies with a usage error; DBI blob_read: invalid number of parameters: handle + 5 Usage: $h->blob_read($field, $offset, $len [, \$buf [, $bufoffset]]) at test.pl line 112. It works correctly when only

blob_copy_to_file issues

2002-04-15 Thread Southern, Mark R
Apologies if this is old hat... i couldn't see any bug reports for this after a superficial search of the archive... I am extracting a clob from an oracle database. The core blob_copy_to_file routine enters an infinite loop by always returning a defined value in its while loop. # while(def