Blob OUT inconsistently returning

[cyates81]

Hello,

I have a stored procedure which has an out parameter of type BLOB. The content of that blob is a large string compressed using the java DeflaterOutputStream class.

I use node-oracle to get the return value and then pass it to zlib.inflate from node.js.

Here's the strange part...if I run the exact same test code a bunch of times in a row, say 20 times, half the time it works fine and half the time zlib throws either an incorrect header check error or an unknown compression method error.

As a test I wrote out the bytes to a file every call and they would always be the same size.
So it seems that either bytes are getting swapped or somehow the blob doesn't return properly around 50% of the time. I'm pretty sure the issue is with node-oracle because as a test I wrote a C# version which calls the same stored procedure and it uncompresses fine every time.

Am I doing something wrong or did I uncover a bug?

oracle.execute('call test_compress(:1)', [new oracle.OutParam(oracle.OCCIBLOB)], function(err, results) {
  console.dir(results.returnParam.length);
  zlib.inflate(results.returnParam, function(err, uncompressed) {
    if (err) {
      console.log(err);
      fs.writeFile('bad1', results.returnParam);
    } else {
      fs.writeFile('compressed1', results.returnParam);
      var StringDecoder = require('string_decoder').StringDecoder;
      var decoder = new StringDecoder('utf8');
      console.log(decoder.write(uncompressed));
    }
  });
});

[cyates81]

I thought I was testing this against the latest commit but was really only testing against the npm version. When using the latest commit it works as expected.

However, I never mentioned that when compiling I get an error on line 271 of executeBaton.cpp saying that pow is ambiguous. I had to add a static_cast<float>.

I'll try to do a pull request tomorrow.