Package Access Mystery Solved - I have been playing around with the DBMS_CRYPTO package, trying to generate a lot of hashes. I want to study the distribution of hashes for different inpu...
All in the Positioning
The testers could not replicate the exact behavior from the customer. They could also not make the system as they expected. They asked me for some help. I got similar results as them. We were at a loss. Then I figured we could stop trying to replicate the issue from the customer. Instead we could try to figure out what was going wrong.
We found some data. But it seemed to be chopped off at the end. Some other data was just all garbled up beyond recognition. The data getting truncated came from a file that was SQL*Loaded. I figured a truncation might be due to wrong positioning in the input file.
I researched the record layout documented in the design. Sure enough, the testers were putting a response in the wrong position in the file. You would think they would have double checked that. I guess everyone is busy. Let's hope this gets us past this problem.